Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / kaki
Look up transformation is used for looking up a value from
OLAP table within a mapping before populating it. For
example, I have empid and I want to get emp name to use in
the next transformation, I would search for it in a look up
table which has the emp name by giving input as emp id.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
what is an ETL or ETT? And what are the different types?
Define slowly changing dimensions (SCD)?
Do we need an etl tool?
What are various etl tools in the market?
can be used COM component in Informatica ?
what are the facilities provided by data warehouse to analytical users?
how would u estimate the size of Lookup transform data and index cache?
Explain different types of partitioning?
What is partitioning? Explain about round-robin, hash partitioning.
flat filevalidation in informatica
Is hadoop a etl tool?
Hi Guys, my requirement is to load 1 yr data from oracle to teradata database through abinitio etl graph.i need to schedule this as a monthly job.but i want to load 12 month data for the first time and from second time it should load last (recent) month data and delete 13th month data. For example For the first time it should load 201208 to 201108 data, second time it should delete 201108 month data and load 201209 month data. I developed garph to load 12 month data ,but i don't know how to handle above requirement as am new to abinitio. i greatly appreciate you help.Thank You.
What is the difference between round-robin partitioning and hash partitioning?
what are Lookup caches options? Including persistent caches.
Explain about the data integration suite features?
