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
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / arunakumaril
(here column names are not mentioned .so,i have taken them
as column1 and column2)
take 2 variables for current value of column1 and previous
value of column1 and use concat function for concatenating
values of column2.
(variableports)curr_col1_val:column1
(variableports)res:if(curr_col1_val=pre_col1_val,concat
(res,column2),column2)
(variableports)pre_col1_val:column1
Is This Answer Correct ? | 4 Yes | 0 No |
Answer / babu
Hi Aruna,
U r answer has small change,i.e one output port and in
aggregator t/r column1 is group by port not column2.
SRC
|
SQ
|
EXP
{
(variable port) var:IIF(col1=var1,concat(var,col2),col2)
(variable port) var1:(col1)
(output port) oup:var
}
|
AGGR(COL1 AS A GROUP BY PORT)
|
TRG
MAPPING DESIGN::
SRC-->SQ-->EXP-->AGGR-->TRG
Is This Answer Correct ? | 4 Yes | 1 No |
Answer / arunakumari l
(here column names are not mentioned .so,i have taken them
as column1 and column2)
take 2 variables for current value of column1 and previous
value of column1 and use concat function for concatenating
values of column2.
STEP1:
use this below logic in expression transformation:-
(variableports)curr_col1_val:column1
(variableports)res:if(curr_col1_val=pre_col1_val,concat
(res,column2),column2)
(variableports)pre_col1_val:column1
STEP2:
Take groupby on column2 in aggregator
Is This Answer Correct ? | 1 Yes | 1 No |
Answer / santosh
HI ARUNAKUMARI,
IAM RAJU,WHAT IS MAPPPING DESIGN OF THIS SCENARIO AND WHERE WE DESIGN LIKE IN TRANSFORMER STAGE OR ANY AND WHAT IS(variableports)& WHICH STAGES ARE SQ AND EXP AND SORTER.
IAM A NEW IN DATASTAGE,PLS EXPLAIN ABOUT THIS CLEARLY
THANKS ADVANCE.
(here column names are not mentioned .so,i have taken them
as column1 and column2)
take 2 variables for current value of column1 and previous
value of column1 and use concat function for concatenating
values of column2.
(variableports)curr_col1_val:column1
(variableports)res:if(curr_col1_val=pre_col1_val,concat
(res,column2),column2)
(variableports)pre_col1_val:column1
Is This Answer Correct ? | 0 Yes | 0 No |
Can you start a batches with in a batch?
In a sequential batch can u run the session if previous session fails?
 Code page compatibly –Where all changes are made to handle the scenario.
In which scenario did you used pushdown optimization?
what is inline view?
Can you start a session inside a batch individually?
What are the new features of the server manager in the informatica 5.0?
If a session fails after loading of 10,000 records in to the target. How can you load the records from 10001 th record when u run the session next time?
Target is zero file and how can you send the email?
write sql query following source table jan feb mar apr 100 200 300 400 500 600 700 800 900 100 200 300 i want the output format like month total jan 1500 feb 900 mar 1200 apr 1500
When do you use mapping parameters? (In which transformations)
How do you set a varible in incremental aggregation