Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 5 Answers
- 10631 Views
- ITC Infotech, TCS, I also Faced
- E-Mail Answers
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 shortcut and copy in Informatica and how two are different with each other?
Enlist few areas or real-time situations where informatica is required.
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
What are the types of schemas we have in data warehouse and what are the difference between them?
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
How to generate or load values in to the target table based on a column value using informatica etl tool.
What is Data Caches size?
Define Pmrep command?
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
Can we create a node as a gateway node and the same node can be assigned to a grid?
Quickly characterize reusable change?
Is it possible to define a single node as a Gateway node as well as worker node?
What is a sequence generator transformation?
Which transformation is needed while using the Cobol sources as source definitions?
What are the informatica performance improvement tips
