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 is exclusive and normal mode for repository services?
Explain the code page compatibility?
What is a repository? And how to add it in an informatica client?
How to update or delete the rows in a target, which do not have key fields?
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
What is meant by a domain?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
What is data caches/ index caches?
What is Index Caches size?
Explain transaction control transformation in informatica
What are the conditions needed to improve the performance of informatica aggregator transformation?
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
what is song in infrmatica...?
How an expression transformation differs from aggregator transformation?
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??