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 / ankur saini er.ankur861@gmail.

hey...i think we can use dynamic lookup too..in dynamic
lookup mark ignore the columns you dont want them tp
participate in lookup process rest for every port specify a
expression for lookup..

GUYs...let me know your comments on this...

Thanks

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to use pmcmd utility command?

586


What is intricate mapping?

594


Describe data concatenation?

578


i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance

1679


Explain the shared cache and re-cache?

617






What is joiner change?

686


What is exclusive and normal mode for repository services?

717


Different qualification between a related rotate toward the sky and isolates look upward?

556


Differentiate between Load Manager and DTM?

1674


What could be the possible resons of locks by user?

665


What is the difference between router and filter?

651


How can we store previous session logs?

572


What is a standalone command task?

661


What is enterprise data warehousing?

617


What is a difference between complete, stop and abort?

644