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
- 10065 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
How to update a particular record in target with out running whole workflow?
Why union transformation is an active transformation?
Why filter transformation is an active one?
How can we store previous session logs?
What is transformation?
What do you mean by filter transformation?
Why update strategy and union transformations are active?
What are the mapping parameters and mapping variables?
Clarify the utilization of aggregator cache record?
What is pmcmd command?
What are the different types of transformation available in informatica.
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
Different qualification between a related rotate toward the sky and isolates look upward?
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
Enlist the differences between database and data warehouse.
