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
- 8883 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 |
Q. We are the loading the table on daily basis it is incremental loading. and A person rahul slary was 10000, so if i check before run my salalr is 10000. but toay there is update that my sal is 15k but that will come to know after the load. braod crtiteria is we donot want to show downstream teams partial updated data. need aproad as etl developer
Which files are created during the session rums by informatics server?
What is reconstalation n What is fact constalation? Correct me if i m wrong in the question.
can u apply SCD2 on flat file tgt? if yes wat is the procedure?
What is an aggregator transformation?
Is it possible to revert a global repository to local one and why?
How will you display "Mr" for male & "Mrs" for female in target table?
How do you recover rows from a failed session
what are the perameter and variable?
What are the types of error logs available in Informatica?
Sequence generator, when you move from develoment to production how will you reset
According to his methodology what all you need before you build a datawarehouse
Teradata 
