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
Answer Posted / 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 |
Post New Answer View All Answers
What is a pre-defined event and user-defined event?
what is informatica metadata?
Where are the source flat files kept before running the session?
What do you understand by term role-playing dimension?
How an expression transformation differs from aggregator transformation?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
If informatica has its scheduler why using third party scheduler?
What is a repository? And how to add it in an informatica client?
explain abt ur project architecture?
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
What are connected or unconnected transformations?
difference between informatica 8.1.1 and 8.6
What is an expression transformation in informatica?
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1