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
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
What is decode in informatica?
What is a rank transform?
Differentiate between router and filter transformation?
What are the types of caches in lookup? Explain them.
What is data caches/ index caches?
What are junk dimensions?
list out all the transformations which use cache?
hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica
Plz can any one say me how to get the informatica certification materials and dumps
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
what is the size of your data warehousing?
tell me about your project functionality
What is the sequence generator transformation in informatica?