My source table look like
ID Name Location Salary
1 ran NULL NULL
1 NULL DELHI NULL
1 NULL NULL 1000
I want my output to look like
ID Name Location Salary
1 ran Delhi 1000
What should be my approach to design a informatica mapping.
Assuming my source is flat file not a Relation table so i
cant use SQL.
- 2 Answers
- 5879 Views
- BirlaSoft, I also Faced
- E-Mail Answers
Answer Posted / abhishek kumar
In aggregator
id group by;
o_name -> max(name);
o_location-> max(location);
o_salary-> max(salary);
connect id to id(target),o_name to name(target),o_location
to location(target),o_salary to salary(target) port;
src->sq->aggregator->target
| Is This Answer Correct ? | 13 Yes | 1 No |
Post New Answer View All Answers
Can anyone tell me the new features in Informatica 9 Version?
What are the components of workflow manager?
What are the databases that informatica can connect to windows?
Could you explain what is enterprise data warehouse?
What are the popular informatica products?
Differentiate between a database and data warehouse?
How do you remove duplicate records in informatica? And how many ways are there to do it?
Global and Local shortcuts. Advantages.
What is DR strategy for Informatica project?
can you please explain me pre session and post session options?
What are the types of caches in lookup?
Explain the difference between mapping parameter and mapping variable?
Differentiate between joiner and lookup transformation?
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
Why do we need informatica?
