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 have a source with 100 records.i have 2 targets.in the first target i want to load first 50 records & in the second target i want to load next 50(or remaining) records.
Define error Threshold?
what are the output files that the informatica server creats during running a session?
How to differentiate between the active and passive transformations?
how to call lookup qualifer in unconnected look;up
what is normalizer transformation?
Clarify the utilization of aggregator cache record?
Dependecy Errors in Informatica ? Do u got any dependency problems while running session? Can any one Explain Clearly.
when informatica 8 series released ?
How can you recognise whether or not the newly added rows in the source r gets insert in the target ?
case and like function in informtica (my source is XML). case when OS Like'%Windows%' and OS Like '%200%' then 'Windows 200' case when OS Like'%Windows%' and OS Like '%200%'and OS like '%64%' then 'windows 200 64 bit' etc.,,
source table have 3 records? and it is sucessfully loaded into target. and 4more records is added in to source .that means 7 records now in source. we have to load the remaining 4 records into the same trgt table with maintian top 3 records. how ?can any one give me the data flow of this logic plz?