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
- 5 Answers
- 8826 Views
- TCS, I also Faced
- E-Mail Answers
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 |
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
Can we update a target table (without primarykey) by using update strategy transformation?
when we create source as oracle and target as flat file, how can i specify first row as column in flat file?
how u know when to use a static cache and dynamic cache in lookup transformation.
Why update strategy and union transformations are active?
i have source as Column1 101 a 101 b 101 c so i want to load target as column1 ---> 101 abc
Using Informatica Visio to generate mappings. I am getting error "Table Definition Not Found Exception Error" while importing the template.
What is lookup transformation?
How can you define user defied event?
1)What is Data Masking in informatica? 2)How to restrict junk characters while loading data into target. 3) what happen if i won't pass sorted input in a transformation.
What are the types of data warehouses?
What is target update override
Teradata 
