i have source flat file like 1 a,1 b,1 c,2 a,2 b,2 c
i want output as 1 a,b,c and 2 a,b,c ...
how can achieve this
Answers were Sorted based on User's Feedback
Answer / siva
Take the mapping as (suppose the columns as C1, c2)
SD --> SQ --> Exp --> Agg --> Tgt
In exp define as
c1 <-- c1
c2 <-- c2
v_2 <-- IIF(c1 = v_1,TO_CHAR(v_2) || ', ' || TO_CHAR
(c2),TO_CHAR(c2))
v_1 <-- c1
o_p1 <-- v_2
In Agg
Group by c1
c2 <-- v_2
c11 <-- LAST(c1)
Tgt is connected as
c1 <-- c11
c2 <-- c2
v_ stands for variable port and o_ stands for output port
I think it can be understood by you
Thanks for your response
Is This Answer Correct ? | 9 Yes | 2 No |
Answer / siva
Use 2 variables one for counter and another for value.
sort all the records by c1 and keep track on c1 and hold
the value in v1. When the v1 and c1 are equal, then
concatenate c2 with v2 other assign c2 with v2. Finaly
connct to aggregator and take last value by grouping the
records by c1.
This will work..
Is This Answer Correct ? | 3 Yes | 1 No |
Answer / ganesh yadav
using Normalizer Transformation we can convert the multiple
columns as multiple rows, multiple rows as multiple columns...
rows: 1 1 1 2 2 2
a b c a b c
answer
column wise
1 a b c
2 a b c
Is This Answer Correct ? | 3 Yes | 6 No |
What is the term PIPELINE in informatica ?
How will you display "Mr" for male & "Mrs" for female in target table?
Label in Informatica. How to remove existing Label.
Can we override a native sql query within informatica?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
A session S_MAP1 is in Repository A. While running the session error message has displayed
What is the difference between Oracle performance and Informatica Percfomance? Which performance is better?
What is the functionality of update strategy?
What is souce qualifier transformation it is active or passive
explain about unit testing? in real time?
Hi all, iam new to informatica, can anyone tell me what is unit testing & how it is done? thank u
hw to load this give the mapping? cty state o/p c1 s1 c1 c1 s2 s1 c1 s1 c1 c2 s3 s2 c3 s4 c1 c3 s2 s1 c2 s3 c3 s4 c3 s2 2 columns should be loaded to one column in target table?