i have source like
X1 10
X2 20
X1 30
X2 40
i want target as
X1 X2
10 20
30 40 in informatica
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
can we override a native sql query within informatica? Where do we do it? How do we do it?
What are junk dimensions?
Different sorts of metadata that stores in the storage facility?
what is the -ve test case in your project.
Explain sessions?
How might you approve all mappings in the archive all the while?
What is the need of etl tools?
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
Under what condition selecting sorted input in aggregator may fail the session?
Please let me know how to make Data masking in informatica..
Please let me know how to make encryption and decryption with example?
What is the difference between Active and Passive transformation?
Explain why we use partitioning the session in informatica?
Explain the different lookup methods used in informatica?
Explain target update override in informatica