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 / isha
Use dynamic file name creation
it will create the file name appended with date
| Is This Answer Correct ? | 0 Yes | 0 No |
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
whats the option in informatica 7 version is outdated in informatica 8 version onwards.
Can we override a native sql query within informatica?
Difference between session variables and workflow variables?
I have table with ID,PRD_DT,PRD_FLAG,CUST_DT,CUST_FLAG I need to get max date and its corresponding flag for both the date columns. Ex:- 1A,10/3/2015,AC,10/3/2015,XY 1A,10/4/2015,AB,10/2/2015,XZ Output needed 1A,10/4/2015,10/3/2015,XY I have 100 million + in the table so avoid self-join...
How can i send first half of the records to one target and Remaining to other target?
why we use datawarehouse
What is olap (on-line analytical processing?
How can we handle two sessions in informatica?
What are the Differences between connected and unconnected lookup?
my source has 2 columns. 1st column data: ABC ABC ABC XYZ and 2nd column data: 1 2 3 4. And my target should be ABC 1 2 3, XYZ 4
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.