Interested to Buy Any Domain ? << Click Here >> for more details...
Hi,
source data is
col1 values are 5,6,7
col2 are 3,2,1
col3 are 8,9,10
and i want to get target as
col1 5,6,7
col2 1,2,3
col3 8,9,10
how to do this one?
- 6 Answers
- 8868 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / siva
Take col1 and col3 in pipeline with a sequece generator,
and sorted values of col 2 in another pipeline with
sequence generator. Join both pipelines by sequence values
and send it to target.
Eg: seq col1 col3
1 5 8
2 6 9
3 7 10
Seq Col2
1 1
2 2
3 3
after joining
col1 col2 col3
5 1 8
6 2 9
7 3 10
I think that resolves your problem.
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / galandekapil
I think we can do this via declaring 3 variables say var1,
var2 and var3 in an expression transformationand say we
have 3 input columns col1, col2 and col3.
var1=max(col1, col2, col3)
var2=IIF(var1=col1 and col2>col3, col2,
else if var1=col1 and col3>col2, col3,
else if var1=col2 and col1>col3, col1,
else if var1=col2 and col3>col1, col3,
else col3
var3=min(col1, col2, col3)
Then assign var1 to target col1, var2 to target col2 and
var3 to target col3. I guess this way we can sort the date
in row.
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / guest
Need to connect to the normalizer transformation and ther
put occurs in the normalizer properties
| Is This Answer Correct ? | 0 Yes | 1 No |
Answer / benz
order by clause
Select * from tablename orderby col2 asc;
| Is This Answer Correct ? | 2 Yes | 6 No |
where to select code page option?
What is difference between a connected look up and unconnected look up?
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
How to do unit testing in informatica?
If we use sorted ports in aggregator transformation and somehow records are not in order by format so what will happen,session fails or it succeeded with incorrect data?
In warehouses how many schemas are there?
can we use bulk loading when we use look in mapping
Can we create two repositories on same database instance in oracle?
how do u tune queries?
what are objects in data warehouse?
HOW CAN I SEND HALF OF THE RECORDS TO ONE TARGET AND REMAINING TO OTHER TARGET?
Whether Aggrigator transformation ignore the null values or consider the null values ? Advance Thanks, Manojkumar
Teradata 
