Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 10599 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Explain why we use partitioning the session in informatica?
How do you load only null records into target? Explain through mapping flow.
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
How would you join a node to the already existing domain?
What are the issues you have faced in your project? How did you overcome those issues?
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
Why union transformation is an active transformation?
What are active transformations.
Implementation methodology
What is the maplet?
How can we delete duplicate rows from flat files?
What is a difference between complete, stop and abort?
What is a filter transformation?
Can you generate sequence numbers without using the sequence generator transformation?
What is the Rank index port in Rank transformation?
