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. 

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain transaction control transformation in informatica

771


Under what condition selecting sorted input in aggregator may fail the session?

677


What is the benefit of partitioning a session?

645


What is the need for an etl tool?

647


How do you promote a non-reusable transformation to reusable transformation?

669






Explain pmcmd command usage in informatica

718


Explain dynamic target flat file name generation in informatica

656


What do you understand by term role-playing dimension?

596


what are the Methods For Creating Reusable Transformations?

658


Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar

2290


What are Dimensional table?

628


What is the fact table?

601


How to generate sequence numbers using expression transformation?

652


What is InformaticaPowerCenter?

702


How we can use union transformation?

620