If the source has duplicate records as id and name columns,
values:
1 a, 1 b, 1 c,
2 a, 2 b,
the target should be loaded as 1 a+b+c or 1 a||b||c, what
transformations should be used for this?
Answer Posted / babu
Sorry Shankar,
small mistake in your logic,
Exp Trans:
ID (I/O)
NAME (I)
V_NAME=IIF(ID=V_ID,V_NAME||'+'||NAME,NAME) (V)
V_ID=ID (V)
O_NAME=V_NAME (O)
=============
remaining is same.
Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is union transformation?
What are the prerequisite tasks to achieve the session partition?
How do you migrate data from one environment to another?
What are the informatica performance improvement tips
Explain about cumulative Sum or moving sum?
State the limitations where we cannot use joiner in the mapping pipeline?
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
How many transformations can be used in mapplets.
Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks
What are the tasks that can be performed using sq?
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
What are the different types of repositories created using informatica?
Explian the Process of deployment groups in informatica
What is meant by query override?
What is aggregate cache in aggregator transformation?