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
- 10272 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
What are the tasks that source qualifier perform?
How to create the source and target database connections in server manager?
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?
How to do the error handling of if ur source is flatfiles?
How do you change a non-reusable transformation to reusable transformation?
How to elaborate powercenter integration service?
How to go to the older version for a mapping?
Which are the different editions of informatica powercenter that are available?
How can you increase the performance in joiner transformation?
What are data-driven sessions?
I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?
How can we use batches?
Differentiate between router and filter transformation?
Describe expression transformation?
How to load data in informatica ?
