Interested to Buy Any Domain ? << Click Here >> for more details...
suppose i have source
101 a
101 b
101 c
101 d i want target like 101 abcd how will u achive this
please give me the answer
- 5 Answers
- 10900 Views
- ITC Infotech, TCS, I also Faced
- E-Mail Answers
Answer Posted / prabodh
S-->SQ-->SORTER-->EXP-->AGG-->TARGET
Sort on the firt port,in exp check prev and curr value by
using var ports,if same concat them ,u will get
101 a
101 a b
101 a b c
101 a b c d
from the Exp trans ,group by first port in the Agg trans ,u
will get last row i.e 101 a b c d.
| Is This Answer Correct ? | 11 Yes | 0 No |
Post New Answer View All Answers
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
Is there any way to read the ms excel datas directly into informatica?
What are the uses of etl tools?
what is the -ve test case in your project.
what is $$$$?
Explain sessions?
What is a surrogate key?
What is a repository manager?
What is a filter transformation and why it is an active one?
Enlist some properties of sessions.
Partition, what happens if the specified key range is shorter and longer
can you please explain me pre session and post session options?
On which transformations you created partitions in your project?
What are the basic requirements to join two sources in a source qualifier transformation using default join?
Write the advantages of partitioning a session?
