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 / 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
What is the format of informatica objects in a repository?
what is the size ur source like(file system or database)? how many record daily come u r banking project?
How many number of sessions can one group in batches?
What is a difference between complete, stop and abort?
What do think which one is the better joiner or look up?
What are the reusable transformations?
define galaxy repository in informatica
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
What are batches?
Which version configuration tool used in ur project?
draw informatica architecture 8.6 ?
Describe an informatica powercenter?
Explain the types of lookup transformation?
What are the components of the workflow manager?