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
what is the difference between cardinality and Nullability?
What is full load & incremental or refresh load?
Explain about the data integration suite features?
State the differences between shortcut and reusable transformation
Can we create Hierarchies in generic datasources?
what is granularity in Data ware House?
explain the methodology of Data Warehousing?(Polaries)
What is tracing level? How many types of transformations supported by sorted input?
where we cannot use sorter Transformation. if we use then we will not get correct data?
Define slowly changing dimensions (SCD)?
what make u disappointmnets in u r career
what are the data sources extracted from logistics cockpit in sap bw project and what is the requirement for it ?
What is a lookup table in etl?
how to load the data to fact table?
What is staging area referring to?