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
- 6427 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
Why update strategy and union transformations are active? Explain with examples.
Define filter transformation?
How identifying bottlenecks in various components of informatica and resolving them?
Explain lookup transformation in informatica
What is the format of informatica objects in a repository?
What is domain and gateway node?
can we override a native sql query within informatica? How do we do it?
What are the types of lookup transformation?
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
What are the different components of powercenter?
In informatics server which files are created during the session rums?
Does an informatica transformation support only aggregate expressions?
What are the types of schemas we have in data warehouse and what are the difference between them?
How can we handle two sessions in informatica?
EXL informatica Questions
