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
- 8681 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 |
what is pre and post sql and what is diff between source presql and target pre sql
What is the difference between bitmap and btree index?
In aggregator transformation, I sort the data before aggregator and select sorted port but still I’m getting an error. What is that error?
What are the various types of transformation?
Source (Flatfile) - Target (1-1 mapping). How to load first or last 20 record to target?
i have different sources in different databases ,that sources may be 100 tables i want to load these tables in to single target how to pearform the task
source table A having 100000 records. and target B table having 100000 records. now iam updating B records using update query. i don't know which record is update in target. write a sql query get all updated records from target table B.
what is target update override and when we use it?
What is the difference between Connected and UnConnected Lookup Transformation.Give me one or two examples please?
Hi ETL gurus can any one tell me with a flow how to implement SCD Type 1 and SCD Type 2 in a single mapping.For some fields SCD type has to be implemented and for some fields scd type has to be implementd..Thank in advance..please let me know in case of any concerns...
How do we implement materialized view?when to use materialized view?
scenario where i can use only concurrent execution of workflow.
Teradata 
