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

Which means the first record should come as last record and last record should come as first record and load into the target file?

0 Answers   Informatica,


What are the main issues while working with flat files as source and as targets ?

0 Answers   Informatica,


What is sorter transformation?

0 Answers  


If we are using an aggregator but forget to mention the group by port .what will be the output??

11 Answers   Nomura, TCS,


How could we generate the sequence of key values without using sequence generator transformation in the target ??

12 Answers   TCS, Tech Mahindra,






What are the steps involved in the migration from older version to newer version of Informatica Server?

0 Answers  


source is a flat file empname, empno, sal ram, 101, 1,000 sam, 102, 2,000 ques: my target needs the data to be loaded as sal -1000 and 2000 excluding commas target empname, empno, sal ram, 101, 1000 sam, 102, 2000 how to implement this?

5 Answers   Polaris,


How does a rank transform differ from aggregator transform functions max and min?

0 Answers  


Session Recovery. 1000 rows in the source of which 500 passed through and then I killed the session. Can you perform a recovery and how

1 Answers   IBM,


I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.

0 Answers  


what are the different types of transformation available in informatica. And what are the mostly used ones among them?

0 Answers  


explain different levels in pushdown optimization with example?

2 Answers   TCS,


Categories