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
- 5710 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 tracing level? How many types of transformations supported by sorted input?
Hi my name is kuldeep singh, i have finished my B.E in computer science and engg in 2008. I have worked with accenture for 17 months and because of family problem i left the job in dec 2009.. i was in data ware housing capability. right now i am working in a BPO as technicla support executive,, i want to move to IT again, please suggest me what shuld i do? its been 1 year gap and i am not able to get into IT...please suggest me ...should i go for informatica certification will that help me to get inot IT. please give ur suggestion..my E mail is is singh.kuldeep2004@yahoo.in
Hi, I've a mapping with flat file source The target update override property for the target table is using update stmt. There is no update strategy between source and target. Also The session has the target properties as Insert , Update as update options checked. Does this mean that recs will be inserted only and the update override will not be applied at all. Thanks
what is dynamic insert?
what are the session parameters? How do u set them?
Explain and compare etl & manual development?
What is the difference between Data Warehousing and Data Mining?
what is the main role of FI on business
Mention few test cases and explain them?
What is etl tool in hadoop?
what are the reports created in mm and sd side using sap bw in a project? name some of them and explain the requirement?
How many types of transformations supported by sorted input?
Do we need an ETL tool? When do we go for the tools in the market?
how do u identify the changed records in operational data?
What are three tier systems in etl?
