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
- 6349 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 View All Answers
What is etl process?
What is partitioning? Explain about round-robin, hash partitioning.
where we cannot use sorter Transformation. if we use then we will not get correct data?
How can you use an Oracle sequences in Informatica ? You have an Informatica sequence generator transformation also. which one is better to use?
when will use SQL override in a lookup transformation?
What is the difference between Data Warehousing and Data Mining?
what are the cubes developed in a sap bw project and what is the requirement for developing it?
What is grain of fact?
A session S_MAP1 is in Repository A. while running the session error message has displayed `server hot-ws270 is connect to Repository B`.what does it mean?
how do u identify the changed records in operational data?
what is data modeling?
How to increase performance without changing anything in mapping.( In prod)
Can we create Hierarchies in generic datasources?
What are cubes and olap cubes?
what is Forward,Reverse and Re_engineering?
