Load data to multiple targets according date. When First time session runs it should send to 1st target,second time session runs then send to 2nd target and goes on how to achieve it
Answer Posted / isha
Use dynamic file name creation
it will create the file name appended with date
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How many ways are there to create ports?
What is informatica? Why do we need it?
What are the different types of transformation available in informatica.
Mention few advantages of router transformation over filter transformation.
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
How to update or delete the rows in a target, which do not have key fields?
Write the unconnected lookup syntax?
What is source qualifier transformation in informatica?
Explain pmcmd command usage in informatica
What is the reusable transformation?
How to update a particular record in target with out running whole workflow?
What is a connected transformation?
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?