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 are objects in data warehouse?

2 Answers   Mind Tree,


How to elaborate powercenter integration service?

0 Answers  


Explain incremental aggregation in informatica

0 Answers   Informatica,


How we can use union transformation?

0 Answers  


what is fact table?

9 Answers  


How i can upload the MainFrame source For Informatica ?

1 Answers  


How you can differentiate between connected lookup and unconnected lookup?

0 Answers  


Define enterprise data warehousing?

0 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,


if we hav 10 records in a file, can we get first record from it by using Aggregator with out using Groupby Port in it?If Yes..let me know the answer plz!!!

8 Answers   IBM,


what is metadata?

8 Answers   Satyam,


What is the status code in stored procedure transformation?

0 Answers   Informatica,


Categories