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 can we update a record in the target table without using update strategy?
Explain constraint based loading in informatica
What is meant by pre and post session shell command?
What is different between the data warehouse and data mart?
how to load rows into fact table in data warehouse
Explain lookup transformation is active in informatica
Under what conditions selecting sorted input in aggregator will still not boost session performance?
To import the flat file definition into the designer where should the flat file be placed?
What is pmcmd command?
write a query to retrieve the latest records from the table sorted by version(scd)
What is the need for an etl tool?
How can we remove the duplicates from flat file source?
How to call shell scripts from informatica?
design of staging area?
What is meant by active and passive transformation?