you have created a lookup transformation for a certain
condition which if true returns multiple rows. when you go
to the target and see only one row has come and not all. why
is it so and how it can be corrected.
Answer Posted / sushmanju
The lookup can return on row in return the lookup
properties is set to get last value/first vale in case of
multiple rows.
This cannot be corrected.
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
Explain etl mapping sheets?
What is etl process?
what is Forward,Reverse and Re_engineering?
what are the cubes developed in a sap bw project and what is the requirement for developing it?
Mention few test cases and explain them?
What is etl process. How many steps etl contains explain with example?
what is an ETL or ETT? And what are the different types?
What are the differences between sql override and update override?
Explain me ETL project architecture in Detail?
A session S_MAP1 is in Repository A. while running the session error message has displayed `server hot-ws270 is connect to Repository B`.what does it mean?
if i have a query as flat file how can we load data to target table
what is pmrep command?
What are materialized views & where do we use them?
Explain the key challenges that you face while performing etl testing.
What is a lookup table in etl?