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
- 6183 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
how do u implement configuration management in Informatica?
Explain what is etl process? How many steps etl contains explain with example?
what are the data sources extracted from logistics cockpit in sap bw project and what is the requirement for it ?
what is the meaning of upgradation of Repository?
Two default user groups created in the repository are____and_____.
Explain about the data integration suite features?
Explain about enterprise scalability and roi of data integration suite?
What are the key benefits of ETL Testing?
What is the difference between Data Warehousing and Data Mining?
how do u really know that paging to disk is happening while u are using a lookup transform?
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?
if i have a query as flat file how can we load data to target table
how do use session mapping parameters ?(in which transformation)
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 etl process? How many steps etl contains?
