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 / jakki

Answers were Sorted based on User's Feedback



you have created a lookup transformation for a certain condition which if true returns multiple row..

Answer / sushmanju

The lookup can return on row in return the lookup
properties is set to get last value/first vale in case of
multiple rows.
This cannot be corrected.

Is This Answer Correct ?    4 Yes 1 No

you have created a lookup transformation for a certain condition which if true returns multiple row..

Answer / 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

you have created a lookup transformation for a certain condition which if true returns multiple row..

Answer / 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

More ETL Interview Questions

What are the various tools used in etl?

0 Answers  

Knowledge on what are the improtant characteristice that we need ot consider while developing an ETL Code

0 Answers  

Give a way in which u can implement a real time scenario where data in a table is changing and u need to look up data from it.How will u configure the look up transform for this purpose?

0 Answers  

Give a way in which u can implement a real time scenario where data in a table is changing and u need to look up data from it.How will u configure the look up transform for this purpose?

1 Answers  

what is the meant by Normalization and de-normalization?

0 Answers  

what is a worklet?

0 Answers  

What are the different ways to deploy the code in informatica?

1 Answers   IBM, Saama Tech, Wipro,

How to delete data which is not in source table?

0 Answers   IBM, Saama Tech, Wipro,

what is a test load?

3 Answers  

What is staging area referring to?

0 Answers  

I have two tables in two different database, so to join these tables which transformation will be better joiner transformation or lookup transformation?

2 Answers   Accenture, Saama Tech, TCS,

How many steps etl contains explain with example?

0 Answers  

For more ETL Interview Questions Click Here
Categories