Interested to Buy Any Domain ? << Click Here >> for more details...
how to convert
101 raja 101 raja sekar reddy
101 sekar---------->
101 reddy
- 2 Answers
- 10197 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / purushotham perumalla
Create variable ports in Expression transformation to
concat name if the number is same as follows
Assume the input field names are number and name
define the variable ports in expression transformation in
the following order
v_flag = iif(number = v_number,0,1)
v_name = iif(v_flag = 1,name,v_name ||' '||name)
v_number = number
O_name = v_name
The output of o_name will be as follows
number o_name
----------------
101 raja
101 raja sekar
101 raja sekar reddy
Add an aggregator transformation after expression and group
by number. output number and o_name from aggr to target.
As aggr outputs last row in each group by deault it will
send 101 raja sekar reddy to the output.
| Is This Answer Correct ? | 3 Yes | 0 No |
What does update strategy mean, and what are the different option of it?
What is transformation?
what are the types of facts with Examples?
if i am having 10 records in source, i want 20 records in target...how will you do it
what is metadata?
What are the measure objects?
what is degenerated dimension?
What is the function of aggregator transformation?
Why update strategy and union transformations are active?
Aggregator transformation is having fields say a,b,c,d,e group by is enabled on a,b,c with sorted input,How the aggregator transformation process the i/p data?or in which way i/p comes to agg transformation
what is session parameters?
What are the joiner caches?
Teradata 
