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
- 10153 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
Write the unconnected lookup syntax and how to return more than one column.
How do you remove duplicate records in informatica? And how many ways are there to do it?
How do you migrate data from one environment to another?
What is an expression transformation in informatica?
What the difference is between a database, a data warehouse and a data mart?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
what is degenerated dimension?
Define Pmrep command?
What is dimensional table? Explain the different dimensions.
Explain about cumulative Sum or moving sum?
How do you load first and last records into target table?
How to use procedural logic inside infromatica?
What is a repository manager?
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
