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
- 9029 Views
- Informatica, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / nitin
Create two mapping pipelines
One pipeline is to
1) Break the record 1|A,1|B,1|C,1|D,2|A,2|B,3|A,3|B using normalizer transformation
1|A
1|B
1|C
1|D
2|A
2|B
3|A
3|B
Then pass the records into a flat file target.
Source-->SQ-->Normaliser--> Target (Output_file1)
Output_file1-->SQ--> Aggregator-->Target(Output_file2)
Create another mapping pipeline where the above records act as the source and the delimiter as '|'.
Use an aggregator transformation to group based on the first column and use the SUM(col2) GROUP BY col1.
write the output to the target file with | as delimiter
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / 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 |
Answer / ankit kansal
There is only one row as per the defined problem. so first you have to break down this one row into multiple rows as separated by delimiter ','.
1|A
1|B
1|C
1|D
2|A...
Now in Expression Transformation using some string functions and later using rank/aggregator T/S you can achieve your result...
http://deepinopensource.blogspot.in
| Is This Answer Correct ? | 0 Yes | 1 No |
Answer / amedela chandra sekhar
By using aggregator t/r we can achieve.
use || function
| Is This Answer Correct ? | 3 Yes | 5 No |
Answer / guest
Aggregator with group by on column with values 1, 2, 3
| Is This Answer Correct ? | 7 Yes | 12 No |
How does the session recovery work.
What is the difference between Bulk Load and Normal Load
How can you display only hidden files in UNIX
Where is metadata stored?
What is meant by a domain?
I am having two tables,say table1 having cols Empid,firstname,lastname,middlename and table2 having Empid,firstname,lastname can i union them using Union t/f?
What are the session parameters?
I have 1200 records how can u send it in aggregator with good performance issues?
What are the unsupported repository objects for a mapplet?
What are the challenges you have faced in your project?
Diffrence between 7.1,8.1 and 8.6
Explain the use of aggregator cache file?
Teradata 
