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 is the maplet?

0 Answers   Informatica,


How the Informatica Server reads perameter file?

1 Answers  


Source-1 No name 1 satish 2 karthik 3 swathi 4 keerthi Source-2 No name 1 satish 2 karthik 5 santhose 6 vasu Target 3 swathi 4 keerthi 5 santhose 6 vasu here i want non matching Records i want how to achieve that

5 Answers   TCS,


tell me the informatica architecture

1 Answers   Banca Sella, Wipro,


what is scd?

6 Answers  






Data transformed successfully from Source table to target table. Now how you will ensure that the data in Target table is proper. I answered will verify one or two records and check Then question was that the Development is doing (1-2 record verification)but as a tester you have to verify the complete data, how you will do?? Please answer

2 Answers  


Hey I am net to informatica? Can any one explain me step by step How scd will work ?

1 Answers   Infosys,


What is the internal processes of integration server in Informatica? How data will be extract and load to the target?

0 Answers   TCS,


Normalizer transformation is not involved in Mapplet.. why???

1 Answers   Wipro,


What if the source is a flat-file? Then how can we remove the duplicates from flat file source?

1 Answers  


What is deployemnt groups, Lables, query and dynamic deployment group.

1 Answers   IBM, SVP,


I have a flat file, in which i have two fields, emp_id, emp_name. The data is like this, emp_id,emp_name 101,soha 101,ali 101,khan 102,siva 102,shanker 102,reddy. how to merge the names so that my output is like this Emp_id Emp_name 101 Soha ali kahn 102 siva shenkar reddy please provide solution

5 Answers  


Categories