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
- 5153 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 |
Suppose I am loaded with questions as I am an experienced etl coder, but not an analytical report builder. I am using analysis services to build a cube but am trying to choose the reporting architecture. Can someone please confirm whether or not reporting services (using the business intelligence report) will allow for slicing and dicing, or is it only a static report builder. Also, if I am using the cube browser in analysis services, where can I put the option of non empty so that I dont see records that are blank.?
What is tracing level?
can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.
What is lookup table in etl testing?
what is session partitioning?
What is meant by incremental load?
List few etl bugs?
what are the concerns of OLTP and DSS systems?
Do we need an ETL tool? When do we go for the tools in the market?
What is virtual Data Warehousing?
what are the data sources extracted from logistics cockpit in sap bw project and what is the requirement for it ?
In informatica, I have 10 records in my source system. I need to load 2 records to target for each run. How do I do this?
Teradata 
