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
- 6456 Views
- I also Faced
- E-Mail Answers
Answer Posted / milind
Even though your lookup is returning multiple rows you are
dealing with one row at the time in the pipeline. so do not
expect all the rows from lookup will be carried to the
target table.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
what is data modeling?
Define slowly changing dimensions (SCD)?
What are snapshots? What are materialized views & where do we use them? What is a materialized view log?
How many steps etl contains?
how do u set partition points in the mapping?
What are snapshots?
What is partitioning? Explain about round-robin, hash partitioning.
how to load the data to fact table?
Difference between flat files and relational sources?
how do u set partition points in the mapping?
What are the types of Data Warehouse applications?
what is the use of structures?how many nodes can u create in a structure?
where is the cache (lookup, index) created and how can you see it.
how to connect to a flatfile through ftp in informatica
SCD2 will work on only dimension tables as well as fact Table?
