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 to do the error handling of if ur source is flatfiles?
Explain what transformation and how many are there in informatica?
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
Describe the impact of several join conditions and join order in a joiner transformation?
How is union transformation utilized?
Write the unconnected lookup syntax?
my source is junk data how will u remove that junk data by using unix please any one replay me
To import the flat file definition into the designer where should the flat file be placed?
what is $$$$?
Can we create a Integration service without a Repository service and vice versa?
How to implement security measures using repository manager?
What is a grid in Informatica?
Separate from an archive server and a powerhouse?
Define mapplet?
What is the use of code page?