in unconnected lookup , what are the other transformations ,
that can be used in place of that expression transformation ?

Answer Posted / uzval_vee

Filter,source qualifier

Is This Answer Correct ?    1 Yes 7 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How big was your fact table

1326


Mention few power centre client applications with their basic purpose?

540


EXL informatica Questions

938


COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1

1543


If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?

8568






Explain scd type 3 through mapping.

589


How do you migrate data from one environment to another?

651


How do you load first and last records into target table?

672


Can you generate sequence numbers without using the sequence generator transformation?

605


update strategy transformation in informatica

646


What are the differences between a connected lookup and unconnected lookup?

654


What if the source is a flat-file?

595


suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do

1738


How do you convert single row from source into three rows into target?

609


What is a filter transformation?

576