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
- 6301 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
EXL informatica Questions
How to join three sources using joiner? Explain though mapping flow.
When do you use sql override in a lookup transformation?
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
I have a flat file, want to reverse the contents of the flat file
What is informatica etl tool?
what is the size of u r source(like file or table)?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
What is joiner change?
How to improve the performance of a session using sorter transformation?
What are Dimensional table?
Why do you use Mapping Parameter and mapping variable?
how tokens will generate?
Can we change Dynamic to Static or Persistent cache? If so what happens?
How to join three sources using joiner?
