Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 4 Answers
- 10184 Views
- ABC, Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / shankar
SQ--->SORTER---->EXP---->AGR---->TGT
1.First pass all records into sorter
seect sort key on id.
2. An pass records into EXP
In exp creat 4 pors like
v_id=id
v_name=nme
v_name1=iif(id=v_id,name||'+'||v_name,name)
o_name=v_name1
3.Next pass all to agr
ini agr creat one port like
o_name_t=last(o_nme).
4.Pass to Target
| Is This Answer Correct ? | 8 Yes | 0 No |
Post New Answer View All Answers
Explain the shared cache and re-cache?
State the limitations where we cannot use joiner in the mapping pipeline?
How to extract sap data using informatica?
Explain Dataware house architecture .how data flow from intial to end?
The question was on time stamp. what is the difference between HH and HH24 when to use when.
How to partition the Session?
COM components can be used in Informatica
What is the function of look up transformation?
Explain lookup transformation is active in informatica
While importing the relational source definition from the database, what are the metadata of source that will be imported?
Describe data concatenation?
What can we do to improve the performance of informatica aggregator transformation?
where to store informatica rejected data?
What is a difference between complete, stop and abort?
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
