i have source like
X1 10
X2 20
X1 30
X2 40
i want target as
X1 X2
10 20
30 40 in informatica
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 |
Why update strategy and union transformations are active? Explain with examples.
What is a joiner transformation?
How can i set break points in debugging mode ? can explain steps please?
What is the surrogate key?
What type of sorting algorithm does the Sorter Transformation use, to do its sorting Operation? 1. Bubble sort 2. Insertion sort 3. Shell sort 4. Merge sort 5. Heapsort 6. Quicksort 7. Bucket sort
What is the difference between Active and Passive transformation?
How to delete duplicate records if we have huge volume of records in a table ? (rowid is not the correct approach)
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
Session S1, S2, and S3. In the session S3 I want to load every Saturday. How it is possible?
which T/r we can use it mapping parmeter and mapping variable? and which one is reusable for any mapping mapping parmeter or mapping varibale?
Q. Informatica workflow, it is running beyond two hours for last couple of runs, normally it completed less then 30 min., hardly 40 min, last couple of run crossing 2 hours and more in that workflow only one session. now it is aasign to you that how to idenitfy the performance issue of the sesion of production.
HOE DO U IMPLIMENT SCHEDULING IN INFORMATICA?