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 |
What is tracing level and what are the types of tracing level?
i have to extract data from a flat file.the flat file has 10 records.i have to extract the 1st and 5th record every time.how is it done.
What is deployment group?
In informatica workflow manager, how many repositories can be created?
what is the necessity to use update strategy?(except for updates)
what is hash table in informatica?
I have source like this year account month amount ----- --------- ------ -------- 1999 salaries jan 9600 1999 salaries feb 2000 1999 salaries mar 2500 2001 benfits jan 3000 2001 benfits feb 3500 2001 benfits mar 4000 -->i need target like this year account month1 month2 month3 ----- --------- -------- -------- -------- 1999 salaries 9600 2000 2500 2001 benfits 3000 3500 4000
What is the use of transformation?
we have 6 records in source , i need 2nd record in one target and 5th record in one target or 2nd & 5th record in same target.
According to his methodology what all you need before you build a datawarehouse
empno sal 1 8000 2 9000 3 8000 4 1000 how to get highest sal wise rankings in rank t/r.
What is lookup change?