I have 2records in target table and this record is deleted in source. Now if I run mapping twice how many records do target will have,  source having 10records. Same with incrementally.  Please  answer me ASAP. 



I have 2records in target table and this record is deleted in source. Now if I run mapping twice how..

Answer / kamleshmishra291

what i understand is when first time run source have two records and it got inserted in target and then source data was deleted and new 10 records were inserted . In this case when you run wf again it will insert 10 records to target then , totally we will have 12 records in target

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Informatica Interview Questions

What are parallel querys and query hints?

1 Answers  


What are the types of error logs available in Informatica?

1 Answers  


What are the conditions needed to improve the performance of informatica aggregator transformation?

0 Answers  


Which is the best place to learn Informatica Powercenter Online Training?

1 Answers  


When will u go for (which means situation) Connected Lookup and Connected Lookup? Pls explain with an example?

5 Answers  


what is workflow varible

1 Answers   HP,


I have 5 sessions s1,s2,s3,s4 & s5 and i want execute s1,s2,s3,s5 after s4. How?

8 Answers   DELL,


What are the types of maping wizards that r to be provided in Informatica?

2 Answers  


My Source qualifier has empno, sal. Now my mapping is like SQ(EMPNO)->AGGR->EXP->TARGET SAL ------------>TARGET ? Is this mapping valid or any issues are there if we design like this?

3 Answers   Span Systems,


What is difference between Mapplet and reusable transformation?

9 Answers   Wipro,


What is the need of building a data warehouse?

2 Answers  


how can u load the data in time dimension?

3 Answers  


Categories