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

In a table, 4 person having same salary. How to get Third person record only?

15 Answers  


If i have one source having 10 ports.In a mapping i use that source one target having that ten ports.Data from 5 ports are going to target through a mapplet and another 5 ports are going to target through another mapplet.Both 2 mapplets are intially passive in nature.But presently my requirment to convert on mapplet to ACtive.How can i do it.

3 Answers   TCS,


what is the end to end process meaning in my project(my project is development)and functionality plz tell me

0 Answers  


Performance tuning in UNIX for informatica mappings?

0 Answers   CGI, CTC,


How many repositories can we create in Informatica?

3 Answers  






how to through logic of informatica using the push down optimization into oracle.

2 Answers   Hexaware,


What is a design?

1 Answers  


Data transformed successfully from Source table to target table. Now how you will ensure that the data in Target table is proper. I answered will verify one or two records and check Then question was that the Development is doing (1-2 record verification)but as a tester you have to verify the complete data, how you will do?? Please answer

2 Answers  


What do you mean by DTM and Load manager and what is difference between load manager and load balancer?

0 Answers  


what are the best practices to extract data from flat file source which are bigger than 100 mb memory?

0 Answers   Wipro,


what r d pre-requiste for update strategy transformation, and differnce between delete n truncate in target session properties for update strategy

2 Answers   TCS,


There is a table with emp salary column how to get the fields belongs to the salary greater than the average salary of particular department. Write a query

7 Answers   IBM,


Categories