How to compare Source and Target table, without using
dynamic lookup?

Answers were Sorted based on User's Feedback



How to compare Source and Target table, without using dynamic lookup?..

Answer / nagaraju bhatraju

YOu can join the Source and target columns at the source
qualifer level,if you have public synonym on the target, so
that the table can be accessed from all the schemas.

Is This Answer Correct ?    6 Yes 3 No

How to compare Source and Target table, without using dynamic lookup?..

Answer / davan

Am not sure ..default join of look is left out join
so...use of joiner t/r with left outer join..we have to
look up.

Is This Answer Correct ?    1 Yes 0 No

How to compare Source and Target table, without using dynamic lookup?..

Answer / xxx

Using Unconnected LKP transformation

Is This Answer Correct ?    0 Yes 0 No

How to compare Source and Target table, without using dynamic lookup?..

Answer / b

using MINUS operator in SQ override

Is This Answer Correct ?    1 Yes 2 No

Post New Answer

More Informatica Interview Questions

what is the Default Source Option For Update Strategy Transformation?

0 Answers   Informatica,


suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?

3 Answers  


What is an MDDB? What is the difference between MDDBs and RDBMSs?

3 Answers  


which quality process u can approach in ur project

1 Answers   CTS,


What are the different options available for update strategy?

0 Answers  






What is Factless fact table ???

12 Answers   Satyam, Tech Mahindra,


Repository user profiles

0 Answers  


wt is informatica file watch timers in aflat i want to get the first record and last record how could i.

1 Answers   CTS,


what is constraint based loading

2 Answers   IBM,


Hi, Can you please send me the Informatica 8 certification exam dumps to my email id rwork.san@gmail.com Thanks, Revathi.

6 Answers   CTS,


Target increases every day even though no new record was inserted

0 Answers   Accenture,


Explain the tuning lookup transformation - informatica

0 Answers   Informatica,


Categories