I have a requirement like i need to get my target file name as targetfileddmmyyyy.txt whenever i am running my workflow where ddmmyyyy represents the
date of workflow running.Please suggest a way to do this in informatica
To achive this..You can use FileName Port in FlatFile target Definition. But, Please note that FileName port is available only from Informatia 8.X onwards.
You will create required file name at Transformation level and pass it to FileName Port. It can be done using Transaction Control Transformation and FileName port. Please check the FaltFile Target properties in Target Designer, you will fine this FileName Port. Also there is a good tutorial in Informatica PowerCenter help files for your scenario, check the topics, Transaction Control & FileName port in Help files. There are other posts in this Forum describing the solution.
Hi Prashanth and All,
was bit struggling to trace were exactly we have the FIleName port to add in target designer!!
Finally got it, so for beginners like me - The FileName port is to be added in Target's Ports tab (Like adding a new port on the right extreme we have an option to create a new 'FileName')..
Hope this helps.