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.
- 3 Answers
- 5691 Views
- I also Faced
- E-Mail Answers
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 and compare etl & manual development?
what is the meant by Normalization and de-normalization?
what happens if the info.server doesn't find the session parameter in the parameter file?
How etl testing is different from database testing?
What are the differences between sql override and update override?
what is the main role of FI on business
What is a materialized view log?
what do u do when DB time takes more?in sap bi
How many steps etl contains?
what is pmrep command?
tell me few points when u become TL
how do u really know that paging to disk is happening while u are using a lookup transform?
What is etl process? How many steps etl contains?
Define Dynamic push down optmization?
What is a staging area? What is the purpose of a staging area?
