On a day, I load 10 rows in my target and on next day if I
get 10 more rows to be added to my target out of which 5 are
updated rows how can I send them to target? How can I insert
and update the record?
Answer Posted / sid
take a look t/f and a update strategy t/f. basing on look
up , if the record exits in target then reject it ,if not
exit insert it,and if the record exist but it is changed
then update it
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What is domain and gateway node?
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
Can u generate reports in Informatica?
explain one complex mapping with logic? sales project?
COM components can be used in Informatica
where to store informatica rejected data? How to extract the informatica rejected data?
What are the tuning techniques you applied during your last project
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
What does command task mean?
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
How do you convert single row from source into three rows into target?
What is an Integration service in Informatica?
Explain load alternative records / rows into multiple targets - informatica
Which transformation is needed while using the Cobol sources as source definitions?
What are the types of caches in lookup? Explain them.