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
- 8408 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
Write the program through which the records can be updated?
What are the different clients of powercenter?
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
What are the tasks that can be performed using sq?
Can u generate reports in Informatica?
What is a sorter transformation?
What is a filter transformation?
Write the different tools in the workflow manager?
While migrating the data from one environment to another environment how would you manage the connections?
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
Explain how to import oracle sequence into informatica?
Please let me know how to make encryption and decryption with example?
what is song in infrmatica...?
How can we store previous session logs?
Suppose we do not group by on any ports of the aggregator what will be the output?
