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
- 6430 Views
- BirlaSoft, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
How to extract sap data using informatica? What is abap? What are idocs?
What are the prerequisite tasks to achieve the session partition?
what are factless facts? And in which scenario will you use such kinds of fact tables.
How we can use union transformation?
where to store informatica rejected data? How to extract the informatica rejected data?
how we can load rejected record's at run time?(not through bad files)
What is an aggregator transformation?
What is persistent lookup cache?
What are pre and post-session shell commands?
What is expression transformation?
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
Which is the t/r that builts only single cache memory?
Can anyone tell me the new features in Informatica 9 Version?
What is rank transform?
