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
update strategy transformation in informatica
Please let me know how to make Data masking in informatica..
In which transformation you cannot drag ports into it?
Explain how many types of dimensions are available in informatica?
What is rank transformation?
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
What is the function of aggregator transformation?
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
What is the use of transformation?
Define pmcmd command?
Explain what are the different types of transformation available in informatica.
if we have a delimiters at unwanted places in a flat file how can we over come those.
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
What do you mean by enterprise data warehousing?
How is union transformation utilized?