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 does the server recongnise the source and target databases.Elaborate on this
what are the reports created in mm and sd side using sap bw in a project? name some of them and explain the requirement?
what are the types in error loging?
What is grain of fact?
What is data cleaning?
what are the cubes developed in a sap bw project and what is the requirement for developing it?
how to do aggregation (year wise quantity ) using only source qualifier, the source is sql server date as datetime data type and target as flat file with year (string datatype)
Mention few test cases and explain them?
how do u set partition points in the mapping?
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 is granularity in Data ware House?
What is partitioning? Explain different types of partitioning?
Hi, I completed MCA in 2006.After studied Informatica,SQL server and basics of reporting tool in one of the training center in chennai.I got subject knowledge only.But I didn't go any job because I scared to face real time.Anyone please advice how can I enter again into this and anyone provide real time exposure with project.
what is different between sequential batch and concurrent batch and which is recommended and why?
how many maximum session supports to multiload in teradata ??