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
- 5687 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
List few etl bugs?
flat filevalidation in informatica
what is granularity in Data ware House?
how can i text accracy of ETL migration? i am very new to data warehousing. we are writing ETL scripts using SCRIPELLA tool. how can i test the correctness of data. and we are generating reports using pentaho . is there any easy way to test the pentaho. how can test these ETL scripts written in scriptella? thanks in advance
give detail on the sales project how many number of dimensions & fact tables are used in projec briefly. how the four fact tables taken in the project.
When do we go for the tools in the market?
what is a worklet?
when u connect the repository for the first time it asks you for user name & password of repository and database both.But subsequent times it asks only repository password. why?
how do u really know that paging to disk is happening while u are using a lookup transform?
What is a materialized view log?
What is Data Vault???
Explain about the data integration suite features?
Explain me ETL project architecture in Detail?
what is the use of structures?how many nodes can u create in a structure?
What is the difference between project backlog and product backlog?
