Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / ashis
Add to sweta's answer:
We use lookup transformation to lookup data from a
relational table, view, synonym or flatfile against another
or the same table, view, synonym or flatfile.
This is mainly(not only)used for SCD's. So that the value
in the source can be compared with the existing target.
Lookup transformation are of different types named and
unnamed.
Mostly used lookup transformation types are Connected lookup
(Persistent Lookup, Dynamic lookup, Cached lookup, Uncached
lookup)
| Is This Answer Correct ? | 7 Yes | 2 No |
Post New Answer View All Answers
What is meant by lookup transformation?
What is the session task and command task?
What is event and what are the tasks related to it?
Can we get 1st record through Informatica(without sequence number).
what is the size of your data warehousing?
Sequence generator, when you move from develoment to production how will you reset
What is exclusive and normal mode for repository services?
what are factless facts? And in which scenario will you use such kinds of fact tables.
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
What is substr in informatica?
How to generate sequence numbers without using the sequence generator transformation?
How many dimensions are there in informatica?
What is native users?
what is the hint? how to use it to reduce the query processing in program?
Explain target update override in informatica
