Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 6298 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
1)Power center server and client on the same machine 2)power center server and client on the different machines What is the basic difference in these two setups and which is recommended ?
What is grain of fact?
what is data modeling?
What do you understand by the term ‘transformation’?
Explain what are the various etl tools in the market?
In Which Transformation We Can Use Having Clause In Informatica?
Define slowly changing dimensions (SCD)?
Explain etl?
what is dynamic insert?
What are materialized views & where do we use them?
What are your responsibilities as an etl tester?
what are Lookup caches options? Including persistent caches.
Compare etl & elt?
what are the reports created in mm and sd side using sap bw in a project? name some of them and explain the requirement?
Can anyone explain me a scenario from banking and finance...more precisely a mapping
