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
- 6458 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 |
How to generate a single mapping for both the historical and incremental load.
how can we load first and last record from a flat file source to target?
7 Answers Infosys, ITC Infotech,
what is the significance of newlookup port in dynamic look up
Can we create multiple integration service on single repository?
Can you copy the session to a different folder or repository?
Hi all, iam new to informatica, can anyone tell me what is unit testing & how it is done? thank u
how many types of dimensions are available in informatica?
How do you migrate data from one environment to another?
my source is junk data how will u remove that junk data by using unix please any one replay me
Without using any transformations how u can load the data into target?
How can we handle two sessions in informatica?
follwing scenario two table using find maximum salary? table a table b 101 xxx 1000 106 6500 103 yyy 5000 108 800 104 din 6000 109 7000 105 dsh 200 110 3000
Teradata 
