Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 6449 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
What are the modules in Power Center
define galaxy repository in informatica
How to update a particular record in target with out running whole workflow?
list out all the transformations which use cache?
How to improve the performance of a session using sorter transformation?
Design a mapping to load a target table with the following values from the above source?
What is dynamic cache?
Explain pmcmd command usage in informatica
Why update strategy and union transformations are active?
Suppose we do not group by on any ports of the aggregator what will be the output?
What happens when a session fails and you click on recover?
Can we change Dynamic to Static or Persistent cache? If so what happens?
Explain lookup transformation source types in informatica
If informatica has its scheduler why using third party scheduler?
What is target designer and target load order?
