Had a discussion with Santhosh Garu regarding target file creation but passing its name from mapping itself and appening the name with date. I had a discussion about this with Nilesh earlier, and even I had tried it at that time.
Again today I did it, I passed the file name from mapping with date appened to it. Below are the steps for it.
1. Import the target file and after importing it, click on the "Add FileName Columns to this table icon". Once you click on it, automatically new port will get added to target table.
2. Import source (File or Relational)
3. Creation a simple mapping.
Source --> Expression (to specify the filename) --> Target
In the expression you specify below as a filename'HelloWorld_' || TO_CHAR(SYSTIMESTAMP(),'DD-MM-YYYY')
4. Create a workflow and specify target directory and target filename at session properties level.
5. file name which you give at session level will get over-ridden by file name which you will pass from mapping.
Please watch below video for the same.http://www.youtube.com/watch?v=QCo929SrBsQ&feature=BFa&list=UUZ4jBpZoYcbYNQAOnuV_edg
Again today I did it, I passed the file name from mapping with date appened to it. Below are the steps for it.
1. Import the target file and after importing it, click on the "Add FileName Columns to this table icon". Once you click on it, automatically new port will get added to target table.
3. Creation a simple mapping.
Source --> Expression (to specify the filename) --> Target
In the expression you specify below as a filename'HelloWorld_' || TO_CHAR(SYSTIMESTAMP(),'DD-MM-YYYY')
4. Create a workflow and specify target directory and target filename at session properties level.
5. file name which you give at session level will get over-ridden by file name which you will pass from mapping.
Please watch below video for the same.http://www.youtube.com/watch?v=QCo929SrBsQ&feature=BFa&list=UUZ4jBpZoYcbYNQAOnuV_edg
Wow.. That's very good explanation. Please keep posting such good stuff.
ReplyDeleteI am new to informatica and this is one of the important interview question. Reallly helpful.
Thanks a lot.