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 / 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 |
Post New Answer View All Answers
How might you approve all mappings in the archive all the while?
What is sq transformation?
What is an expression transformation?
How can we improve session performance in aggregator transformation?
Explain the mapping variable usage example in informatica
What are the different components of powercenter?
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
Explain load alternative records / rows into multiple targets - informatica
Explain the etl program with few examples.
How to call shell scripts from informatica?
Differentiate between reusable transformation and mapplet.
What is the difference between router and filter?
Explain sql transformation in script mode examples in informatica
Clarify the utilization of aggregator cache record?
How to load the data from people soft hrm to people soft erm using informatica?