when should one create lookup transformation ?
Answers were Sorted based on User's Feedback
Answer / 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 |
What are your responsibilities as an etl tester?
Identifying the bottlenecks in various components of Informatica and resolving them.
how would u estimate the size of Lookup transform data and index cache?
where is the cache (lookup, index) created and how can you see it.
What is grain of fact?
when should one create lookup transformation ?
how can i text accracy of ETL migration? i am very new to data warehousing. we are writing ETL scripts using SCRIPELLA tool. how can i test the correctness of data. and we are generating reports using pentaho . is there any easy way to test the pentaho. how can test these ETL scripts written in scriptella? thanks in advance
What is etl tool in hadoop?
What is tracing level and what are the types?
WHY CANT WE SEE THE DATA IN DATASET
What is a staging area? What is the purpose of a staging area?
Explain different types of partitioning?