Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 6369 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
what is session partitioning?
where are the log files generally stored.Can you change the path of the file.what can the path be?
What are the key benefits of ETL Testing?
what make u disappointmnets in u r career
Knowledge on what are the improtant characteristice that we need ot consider while developing an ETL Code
my name is amar i want display 1st line A 2nd line M 3rd line A 4th line R in database & informatica
in sap bw project at what scenario generic extraction is used and why explain and also tell why you used calendar day option explain?
How can write SQL Overwrite to get Daynamic rows from the source in SQ transformation!(Any Example)
How many steps etl contains?
How to load Session Statistics (Workflow name, TgtRows, Rejected Rows, SessStartTime,SessEndTime..)into a database table ?? Another Question: I want to pass values from oracle table or Flat file in Mapping parameter/Variable.. What is the method for that..Please provide me the solution step by step
What is partitioning? Explain about round-robin, hash partitioning.
how do u decide whether u need to do aggregations at database level or at Informatica level?
Teradata 
