Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Data Warehouse >> ETL
  2. Suggest New Category

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.

Question Posted / sagar

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


Please Help Members By Posting Answers For Below Questions

What are snapshots?

1030

What is etl process? How many steps etl contains?

1083

What are your responsibilities as an etl tester?

1249

Define slowly changing dimensions (SCD)?

1100

Which transformation we use to convert 'NA' to 'Not Available'

1316

Hi, can anyone plz share the project architecture for etl testing(banking domain) plz explain the architecture .

3083

Define Dynamic push down optmization?

2348

what is data modeling?

2356

What do you understand by active and passive transformations?

981

Explain do we need an etl tool? When do we go for the tools in the market?

1067

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

2532

What is etl process. How many steps etl contains explain with example?

1001

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

2282

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?

2295

What is a staging area? What is the purpose of a staging area?

938