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
Mention few power centre client applications with their basic purpose?
What is a snowflake schema?
What is rank index in rank transformation?
Explain incremental aggregation in informatica
What are the issues you have faced in your project? How did you overcome those issues?
What is the status code in stored procedure transformation?
What do you mean by worklet?
What is the difference between a repository server and a powerhouse?
What are the differences between oltp and olap?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
What are active and passive transformations?
What is a predefined event?
What is fact table? Explain the different kinds of facts.
my source is junk data how will u remove that junk data by using unix please any one replay me
What is the difference between stop and abort in informatica