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 shd be loaded as
1 a+b+c or 1 a||b||c, what transformations shd be used for
this?
- 3 Answers
- 13686 Views
- CTS, Wipro, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / rajesh.a
We need to use sorter,Expression and aggregator transformations to do this
1.Sort by ID
2.Take 2 variable ports one for id and one for name and store the values of id and keep on comparing with current id i.e variable is having previous id.
so,if previous id=current id then (variable name)||name otherwise only name.assign the variable name to output port
3.Use aggregator and use last or max(len(name)) to get the result
| Is This Answer Correct ? | 16 Yes | 0 No |
Answer / saritha
you can use normalizer or expersion transformation.
| Is This Answer Correct ? | 2 Yes | 5 No |
Answer / somnath pain
In source qualifier use this query
select name from table_name group by id
now apply an aggregator transformation to concate the name
according to the group id.
| Is This Answer Correct ? | 2 Yes | 7 No |
Explain the difference between mapping parameter and mapping variable?
Hi, I am unable to connect ports from two Active trasformations to another active transformation ? Why is it so? Why it is designed like that? Some rules has been designed like this that is We can't connect passive and another passive to active.Can any one please letme know all these rules. Ex:- I am trying to connect filter1 and filter2 to another filter. Please answer me Advance Thanks
How can you define user defied event?
What is the benefit of session partitioning?
A session S_MAP1 is in Repository A. While running the session error message has displayed
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
Enterprise data warehouse your projects phase by phase explain?
what r the propertes of workflow? and write quary to select dept more ten employess in dept.?
what is bridge tables in informatica
Which transformation is needed while using the Cobol sources as source definitions?
How many ways you create ports?
performance wise which one is better in joiner and lookup transformation
Teradata 
