Interested to Buy Any Domain ? << Click Here >> for more details...
I HAVE A SOURCE FILE CONTAINING
1|A,1|B,1|C,1|D,2|A,2|B,3|A,3|B
AND IN TARGET I SHOULD GET LIKE
1|A+B+C+D
2|A+B
3|A+B
WHICH TRANSFORMATION I SHOULD USE
- 5 Answers
- 9178 Views
- Informatica, I also Faced
- E-Mail Answers
Answer Posted / nitin
1) Src-->SQ->Normalizer-->Target
The first pipeline breaks the rows and convert to columns and then write to target file.
1|A
1|B
1|C
1|D
2|A
2|B
3|A
3|B
2)Src->SQ->Exp->Target
The second pipeline receives the above output with '|' as delimiter and passes to expression.
In the expression transformation concatenate the second column with + for the same first column and then write to target with | as delimiter
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the conditions needed to improve the performance of informatica aggregator transformation?
Reusable transformation and shortcut differences
draw informatica architecture 8.6 ?
What is sq transformation?
What is target designer and target load order?
What do you mean by worklet?
Where are the source flat files kept before running the session?
What are the different transaction levels available in transaction control transformation?
What is the function of look up transformation?
Clarify the utilization of aggregator cache record?
if we have a delimiters at unwanted places in a flat file how can we over come those.
Enlist some properties of sessions.
How can we improve session performance in aggregator transformation?
What do you understand by a term domain?
What could be the possible resons of locks by user?
