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
- 9228 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 |
Do you have to change the reject file b4 using reject loader utility.
Where do you create/define mapping parameter and mapping variable?
Can you copy the session to a different folder or repository?
1)how to generate sequnce numbers in informatica without using sequnce genarator transformation. 2)i have number of records in my sourse, but iwant to display first and last record only. how it is possible in informatica. 3)i want to update the records without using updatestrategy transformation. 4)what is diffrance between ab-intio and datastage than compared to informatica. 5)what is the latest version of informatica in our field.
Differentiate between mapping parameter and mapping variable?
Where is the cache stored in informatica?
what is upstream and downstream transformation?
What is joiner transformation in informatica?
what are the unix commands to start the wrk flow ?
i have source in oracle 10g,oracle 8i how will u take the data from two sources
how to run the batch using pmcmd command
How do you change a non-reusable transformation to reusable transformation?
Teradata 
