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
- 6302 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 is InformaticaPowerCenter?
What is a filter transformation?
Define update strategy?
What is the format of informatica objects in a repository?
what are factless facts? And in which scenario will you use such kinds of fact tables.
What is the difference between Active and Passive transformation?
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
What does reusable transformation mean?
What is main use of mapplet?
How can we create index after completion of load process?
differences between service based and product based?
Mention few power centre client applications with their basic purpose?
Parameter and variable differences
Differentiate between a repository server and a powerhouse?
Write the unconnected lookup syntax?
