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
- 8151 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 |
Explain the mapping variable usage example in informatica
What is the difference between a table and the materialized view?
What is session task and command task?
What is informatica? Why do we need it?
I have scenario, i have 10 worklflows and i want run the 1st workflow first and immediately i want to run 10th workflow has to run and am not bothering of 2 to 9 workflows? can any one help me how to do this? Thanks in advance.....
What are the types of maping in Getting Started Wizard?
how to declare array in plsql?
What are active transformations.
What can we do to improve the performance of informatica aggregator transformation?
How many numbers of sessions can one group in batches?
what are the perameter and variable?
What is a joiner transformation and why it is an active one?
Teradata 
