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
- 10328 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
What is the difference between stop and abort in informatica
What do you understand by term role-playing dimension?
What is source qualifier transformation in informatica?
what is the size of u r source(like file or table)?
In informatics server which files are created during the session rums?
What is a joiner transformation and why it is an active one?
How you prepared reports for OLAP?
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
What the difference is between a database, a data warehouse and a data mart?
Explain where to store informatica rejected data? How to extract the informatica rejected data?
What is the function of union transformation?
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
What is Data Caches size?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
