what is diff between IN and EXIT commands



what is diff between IN and EXIT commands..

Answer / kamesh

IN: Where they r 2 tables dept and emp the records which r
matched records present in both the table will displayed.


EXIT:the all records are displayed including the records
which are matched.

Is This Answer Correct ?    6 Yes 0 No

Post New Answer

More Informatica Interview Questions

how to delete duplicate records by using filter transfermation?

3 Answers  


Explain the different dimensions.

0 Answers  


What are the features of complex mapping?

0 Answers  


Partition, what happens if the specified key range is shorter and longer

0 Answers   Cap Gemini,


Hi If i had source like unique & duplicate records like 1,1,2,3,3,4 then i want load unique records in one target like 2,4 and i want load duplicate records like 1,1,3,3 then can any body please send me what is th scnario. my mail i shek.inform@gmail.com

6 Answers   HCL, Schneider,






Change Data Capture in Informatica,using Incremental Aggregation.How can i identify the these data in Target table.

2 Answers  


1:when we develop a project what are the performance issue will raise?? KPIT 2:if a table have INDEX and CONSTRAINT why it raise the performance issue bcoz when we drop the index and disable the constraint it performed better??KPIT 3:what are unix commands frequently used in informatica??

1 Answers   KPIT,


What is a surrogate key?Why we use it in a mapping?Pl give an example.

4 Answers   PCS,


there is a comma separated flat file as source and there is a column in that one field is having space like "rama krishna" like that what happens when this is used as source

2 Answers   TCS,


There are n numbers of flatfile of exactly same format are placed in a folder .Can we load these flatfile's data one by one to a single relational table by a single session??

9 Answers   TCS,


what is metadata?

6 Answers  


what is the need of session partitioning... how it is useful in real time

3 Answers   Amazon,


Categories