Interested to Buy Any Domain ? << Click Here >> for more details...
i have source like
X1 10
X2 20
X1 30
X2 40
i want target as
X1 X2
10 20
30 40 in informatica
- 2 Answers
- 8144 Views
- HP, I also Faced
- E-Mail Answers
Answer Posted / sushma
SOURCE--->SOURCE QUALIFIER ----> EXPTRANS1 -----> FILTER ---
--> EXPTRANS2 ------> TARGET
In EXPTRANS1, concatenate X1 and X2 values for every 2nd
record (ie X= X2). Lets call this output column as
x1x2_value
Note: I am concatenating for every second record as X1 and
X2 appear alternatively In your sample data,
In the filter transformation, have the filter condition
X='X2' (only these recs have the concatenated data)
In EXPTRANS2, Using substr to split the data into X1 and X2
and load it into target table
| Is This Answer Correct ? | 4 Yes | 3 No |
Post New Answer View All Answers
Design a mapping to load the cumulative sum of salaries of employees into target table?
What are the differences between joiner transformation and source qualifier transformation?
Why sorter is an active transformation?
How does a rank transform differ from aggregator transform functions max and min?
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar
Explain what are the different versions of informatica?
How do you set a varible in incremental aggregation
How do you load first and last records into target table?
How to differentiate between the active and passive transformations?
Explain what transformation and how many are there in informatica?
What do you understand by term role-playing dimension?
What is substr in informatica?
Quickly characterize reusable change?
How many ways are there to do 'remove duplicate records in informatica'?
What is primary and backup node?
