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
- 11043 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
What are some examples of informatica etl programs?
Is it possible to use a client with different version than that of its Informatica server?
What are Dimensional table?
Informatica settings are available in which file?
What does command task mean?
How might one distinguish in the case of mapping is right or not without associating session?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
How many ways a relational source definition can be updated and what are they?
Is there any target staging area in informatica not staging area
How to create Target definition for flat files?
How do you use reject loader.
What do you mean by channel change?
How many transformations can be used in mapplets.
How can you validate all mappings in the repository simultaneously?
Can anyone tell me the new features in Informatica 9 Version?
