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

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the format of informatica objects in a repository?

598


Write the prerequisite tasks to achieve the session partition?

641


is it possible to index the data in cache of lkp transformation ?

1524


what is informatica metadata?

598


Can we create a node as a gateway node and the same node can be assigned to a grid?

637






Under which circumstances, informatica server creates reject files?

589


What is blocking transformation?

717


What is aggregator transformation in informatica?

544


What are the uses of etl tools?

647


What are the tasks that source qualifier perform?

629


How identifying bottlenecks in various components of informatica and resolving them?

583


Can we override a native sql query within informatica?

628


Slowly changing dimensions, types and where will you use them

1271


My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?

1455


Explain scd type 3 through mapping.

578