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 / 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 and data mining?
what are the reporting tools and difference between them?
What are the various tools used in etl?
What is abap? What are idocs?
tell me few points when u become TL
What are the different etl testing categories as per their function?
SCD2 will work on only dimension tables as well as fact Table?
What are your responsibilities as an etl tester?
how does the server recongnise the source and target databases.Elaborate on this
Just Completed the informatica Certification ,for Dumps please email me on infamaddy@gmail.com i will send it to youÂ
What is virtual Data Warehousing?
how do u really know that paging to disk is happening while u are using a lookup transform?
What are the modules in Power Mart?
When do we analyze the tables?
Explain do we need an etl tool? When do we go for the tools in the market?