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
- 10183 Views
- ABC, Cap Gemini, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
Answer / babu
Sorry Shankar,
small mistake in your logic,
Exp Trans:
ID (I/O)
NAME (I)
V_NAME=IIF(ID=V_ID,V_NAME||'+'||NAME,NAME) (V)
V_ID=ID (V)
O_NAME=V_NAME (O)
=============
remaining is same.
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / mithilesh kumar rai
First Use Expression and then Use Aggregater
After Expression U will receive
1 a
1 a b
1 a b c
2 a
2 a b
2 a b c
then use aggregater group by key 'ID'
After Aggregater u will receive
1 abc
2 abc
| Is This Answer Correct ? | 2 Yes | 2 No |
Answer / souvik
We need to have a Lookup with a Dynamic Cache, a Router, an Expression and then an Update Strategy..... The Lookup will be on the Target Table..... So when the ID is coming for the first time, it wont found any data on the lookup table.... This can be directed for Insertion to the Target Table via a Router.... Then when the same ID is coming for the second time, it will Lookup on the Target Table and will found that the row with the ID exists.... Hence both the columns from the source table and both the columns from the Lookup are taken forward into the Router and then to an Expression Transformation where the second port is Concatenated. Then the ID port and this port is taken to the Update Strategy transformation for Update...
| Is This Answer Correct ? | 1 Yes | 2 No |
What is difference between Mapplet and reusable transformation?
Explain why we use partitioning the session in informatica?
i have flat file it contains 'n' number of records, i need to send half of the records to one target table and Remaining half to another target table: pls full details
8 Answers L&T, TCS, UnitedHealth Group, Wipro,
What is Performance tuning in Informatica?
i have flat file it contains 'n' number of records, i need to send half of the records to one target table and Remaining half to another target table. can any tell me procedure.
What if the source is a flat-file?
1,If there are 3 workflows are running and if 1st workflow fails then how could we start 2nd workflow or if 2nd workflow fails how could we start 3rd workflow?
4 Answers CompuSoft, EDS, TCS,
draw informatica architecture 8.6 ?
How to extract original records at one target & Duplicate records at one target? {with out using EXPRESION transformation and sequence generator transformation?}<-this is important
Difference between STOP & ABORT in Informatica.
3 Answers Accenture, Wells Fargo,
source target --------- -------- name no sal name no sal max_sal r 10 1000 r 10 1000 3000 y 20 3000 y 20 3000 3000
From where we can start or use pmcmd?
Teradata 
