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
- 5859 Views
- BirlaSoft, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / rajan raorane
Use the below Mapping
Flat file-->SRC Qualif-->EXp-->Filter( With not null
condition on each port)-->Normalizer-->output
| Is This Answer Correct ? | 1 Yes | 2 No |
What are the types of maping in Getting Started Wizard?
What is session task and command task?
how many types of dimensions are available in informatica?
Plz..let me know differences between Informatica 7.1 and 8.1?
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
what is the difference between stop and abort
Explain informatica architecture - version 8 / 9
what are the unix commands to start the wrk flow ?
in my source i have 100 records, and 3 targets, i want to load 1st record into 1st target,2nd record into 2nd target,3rd record into 3rd target again 4th target into 1st target and vice versa,how to achieve this?
What is souce qualifier transformation it is active or passive
What are the circumstances that infromatica server results an unreciverable session?
How to send duplicates to one target and unique rows to one target?target is empty
Teradata 
