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.
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
how do u implement configuration management in Informatica?
Identifying the bottlenecks in various components of Informatica and resolving them.
what is data modeling?
what is the use of server?
what is the use of server manager?
what is the difference between cubes and package in cognos
1.Identify and discuss the problems which are occurred during data quality verification for the single-source and multi-source problems. 2.Testing has very important role in DWH. In ETL testing phase, how can we perform the integration testing and regression testing? 3.What are the perquisites of system testing and regression testing in ETL phase?
What are dimensions?
How to recover a workflow? What are the different approaches?( In prod i.e no access to modify)
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?
what is Forward,Reverse and Re_engineering?
What are the various tools used in etl?
Explain about round-robi?
What is staging area referring to?
Explain etl mapping sheets?