I have a scenario with lookup table. in that lookup table have
colomns, but i need to process only 10 colomns out of 50.
Please te me how can we acheive it?

Answer Posted / priyank

Except the 10 columns, if any other column is not being
used for any matching/filter condition, then remove the
columns from the look up table and the columns which are
used in the filter condition but are not taken forward in
the target, uncheck the oputput port and keep them as Input
port.

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Why sorter is an active transformation?

758


permutations of mapplet

2043


How many dimensions are there in informatica?

632


COM components can be used in Informatica

1880


Briefly define reusable transformation?

631






How to use pmcmd utility command?

586


What is a sequence generator transformation?

580


Explain the scenario which compels informatica server to reject files?

661


where to store informatica rejected data? How to extract the informatica rejected data?

607


hi real timers . iam waiting for ur reply regarding ETL TESTING

1814


What is update strategy transform?

580


What is Cognos script editor?

3790


What is meant by incremental aggregation?

589


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

654


What are the components of Informatica? And what is the purpose of each?

624