I have 2records in target table and this record is deleted in source. Now if I r

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.

Question Posted / amit

1 Answers
4448 Views
Cipla, Quintiles, I also Faced
E-Mail Answers

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 difference between Power Centre and Power Mart?

5 Answers TCS,

If we use sorted ports in aggregator transformation and somehow records are not in order by format so what will happen,session fails or it succeeded with incorrect data?

1 Answers Amdocs,

Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?

0 Answers

How to extract the informatica rejected data?

0 Answers

In operator is used in which transformation in informatica 8.6.0

5 Answers Virtusa,

What is the Difference between PowerPlay transformer and power play reports?

1 Answers

i have different sources in different databases ,that sources may be 100 tables i want to load these tables in to single target how to pearform the task

14 Answers Altisource, TCS,

design of staging area?

0 Answers

Had any one faced informatica(ETL/Developer), Datawarehouseing interview in UK. Than plz help me (i have any exprience of 3yrs informatica,datawarehousing,oracle,teradata) 1.hw the procedure will b here 2. wht type of question's they will b asking. 3.In which area they concertate more. since this is the first time im facing interview in UK. plz help ASAP.it will b a great help for me thanks to All in Advance

2 Answers

how the informatica server sorts the strings values in rank transformations?

3 Answers TCS,

we have a parameter file in Unix location where we have .txt files and those file will be used as source in informatica. I cannot use source file name directly as file name will keep on changing in unix location. I need to define $$InputFile as parameter. Can anybody send me the parameter file and the steps to handle this.

2 Answers Infosys, TCS,

have u done any performance tuning? how u ll do?

0 Answers IMB, TCS,

For more Informatica Interview Questions Click Here