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

If a table contains 100 records we have to fetch 50-100 records from source to target?how

7 Answers   CSC,


How to load duplicate records in to a target table which has a primary key?

2 Answers  


in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use

0 Answers   TCS,


two tables from two different databases r there . both having same structure but different data . how to compare these two tables ?

10 Answers   HP, Patni,


one source to target loading insert new rows and update existing rows?

3 Answers   Polaris,






can we use bulk loading when we use look in mapping

1 Answers   TCS,


suppose we will take flatfile target and load type is bulkload the session fails why please give me the answer

1 Answers   TCS,


can we use self join in informaitca?

3 Answers   IBM,


can any one give some examples for pre sql and post sql(Except dropping and creating index).

0 Answers   Zensar,


In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?

1 Answers   HP,


with out using update strategy transnsformation how to update the data in mapping level

1 Answers  


What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?

2 Answers   TCS,


Categories