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
- 8184 Views
- HP, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / raji
Well,As of my knowledge.....
first u have to take eliminet the duplicates.....like
SRC---->SQ--->AGG---->TGT
in aggr t/f give the group by for both ports...
after this step just use a normalizer t/f to convert these
rows in to columns...
| Is This Answer Correct ? | 2 Yes | 0 No |
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 |
what is junk dimension
Is it possible to update the target table with PK?
why we use source qualifier transformation?
Where is metadata stored?
What is the method of seperating unique and duplicate records in session level?
2 Answers Emphasis, JBL, Wipro,
Can anyone know that what is the Source File limitation in Informatica? To be more precise .. how many flat file we can use as a source in a mapping if.. 1) The Structure of flat files are same & 2) If the Structure of flat files are different. Please explain the procedure also if it dosn't bother one much!!
By using Transformation i need top most 5 employee salary from each deptwise? Deptno 10,20,30? which transformation we need to use?
How many transformations can be used in mapplets.
Explain about HLD and LLD ?
What are set operators in Oracle
What are events in workflow manager?
Explain lookup transformation in informatica
Teradata 
