i am having my source columns and values as
c1 c2 c3
1 1 a
1 2 b
1 3 c
2 1 d
2 2 e
and i want to load this values in to target as
that is values of c3 must be concatenated to single value for each value of c1 and loaded into target.
For c1 = 1
c3 = a || b || c
For c1 = 2
c3 = d || e
can any one help me how to do this in dmc..
thanks in advance.
thenmozhiThis message has been edited. Last edited by: thenmozhi,
Did you do a search to see if this has been asked before ??
The following link show how to do this in WebFOCUS.
Im guesssing that by "in dmc" you mean that you are using the Data Management Console with a DataMigrator server and want to create a Data Flow with with a SQL SELECT statement. You can do that like this.
SELECT C1 , MAX(IF (C2 = 1 , C3 , '' ))|| MAX(IF (C2 = 2 , C3 , '' ))|| MAX(IF (C2 = 3 , C3 , '' )) AS C3 FROM c123 T1 GROUP BY C1
|Powered by Social Strata|