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
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
How to update a particular record in target with out running whole workflow?
Enlist some properties of sessions.
What is the fact table?
What is resilience time?
Explain lookup transformation in informatica
What is Index Caches size?
what is unit testing?tell me proceedure
Explain the types of lookup transformation?
what is the -ve test case in your project.
What are the types of schemas we have in data warehouse.
What is different between the data warehouse and data mart?
What if the source is a flat-file?
Different circumstance which drives informatica server to expel records?
Why union transformation is an active transformation?