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
- 6297 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 are the production issues in datastage?
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
What is full load & incremental or refresh load?
how does the server recongnise the source and target databases.Elaborate on this
Hi, can anyone plz share the project architecture for etl testing(banking domain) plz explain the architecture .
How many types of transformations supported by sorted input?
What is etl process?
What is Data Vault???
how do u set partition points in the mapping?
Assume u have a 24CPU machine with 24GB RAM, suggest how u would like to configure Informatica ,like number of concurrent sessions, RAM requirements etc,max partitions that u would permit per mapping.
Explain the use lookup tables and Aggregate tables?
What is partitioning? Explain different types of partitioning?
What is initial load and what is full load?
explain about your project architecture in ssis..could u please send to my mail..vinod.kjvk@gmail.com
what is the use of server?
