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
- 6348 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
What is meant by incremental load?
What are the types of Data Warehouse applications?
what is the difference between cardinality and Nullability?
What is a materialized view log?
A mapping contains source table S_Time(stat_year,end_year) target table TIM_DIM(date,day,month,year,quarter) stored procedure transformation: A procedure has two parameters I_end_year and output parameter as O_date ,day , month, year, quarter, If this session is running, how many rows will be available in the target and why?
what is granularity in Data ware House?
what do u do when DB time takes more?in sap bi
how do u estimate the depth of the session scheduling queue? Where do u set the number of maximum concurrent sessions that Informatica can run at a given time?
what are the data modeling tools you have used?(polaris)
What are snapshots? What are materialized views & where do we use them? What is a materialized view log?
when will use SQL override in a lookup transformation?
What is staging area referring to?
What are the different etl testing categories as per their function?
what is the difference steps for data modeling?
how do u handle performance issues in Informatica . where can u monitor the performance ?
