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 / sagar
check the data type of the out put value ie it should be
the same with the out put value ,check the null coloumns
before giving the condition.
update me if iam wrong
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
What are snapshots?
What is etl process? How many steps etl contains?
What are your responsibilities as an etl tester?
Define slowly changing dimensions (SCD)?
Which transformation we use to convert 'NA' to 'Not Available'
Hi, can anyone plz share the project architecture for etl testing(banking domain) plz explain the architecture .
Define Dynamic push down optmization?
what is data modeling?
What do you understand by active and passive transformations?
Explain do we need an etl tool? When do we go for the tools in the market?
please tell me any easy ways of testing the Data warehouse project. In my project we are not using any tools for ETL. we are writing scripts in SCRIPTELLA. And we using Pentaho tool for Reporting How can i test all these. please tell me ASAP. thanks in adavance
What is etl process. How many steps etl contains explain with example?
Dear All, Can anyone tell me that from where i can get Power Center 8.5 S/W for Linux and how can i install Power Center 8.5 or any 7.x series on Linux Platform. Thanks in advance
1.Identify and discuss the problems which are occurred during data quality verification for the single-source and multi-source problems. 2.Testing has very important role in DWH. In ETL testing phase, how can we perform the integration testing and regression testing? 3.What are the perquisites of system testing and regression testing in ETL phase?
What is a staging area? What is the purpose of a staging area?