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
- 6443 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
What are the features of complex mapping?
Which version configuration tool used in ur project?
What is session task and command task?
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance
What are the transformations that are not supported in mapplet?
Differentiate between sessions and batches?
Why update strategy and union transformations are active? Explain with examples.
What is parallel processing in informatica?
What is incremental aggregation?
What is option by which we can run all the sessions in a batch simultaneously?
What is dynamic cache?
Differentiate between joiner and lookup transformation?
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
Design time, run time. If you don't create parameter what will happen
