Follow Our FB Page << >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

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

Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM

1 Answers   IBM,

what is update strategy transformation ?

7 Answers   TCS,

complex mapping ur project u r invlve can u explain and give real time example give me ?

0 Answers   HGS, TCS,

i have to extract data from a flat file.the flat file has 10 records.i have to extract the 1st and 5th record every is it done.

10 Answers   Emirates, IBM,

How many ways a relational source definition can be updated and what are they?

0 Answers   Informatica,

How will you check the bottle necks in informatica? From where do you start checking?

3 Answers   HCL,

Is scd logic we have lookup right to compare the values with source and target,instead of lookup can u have any transformation or any way to do this?

2 Answers  

how to create user defined function (udf) in informatica

0 Answers   Informatica,

which one is better either active or passive transformation in informatica

1 Answers  

Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?

0 Answers  

Without source how to insert record to target?

6 Answers  

Can we update the data in flat file using update strategy?

3 Answers