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
- 9101 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 |
If we are using an aggregator but forget to mention the group by port .what will be the output??
There is a table with emp salary column how to get the fields belongs to the salary greater than the average salary of particular department. Write a query
What is the status code?
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
What are the types of caches in lookup? Explain them.
server hot-ws270 is connect to Repository B. What does it mean?
How to delete first 3 rows & last 3 rows in target table in informatica
i have 5 session (s1,s,2,s3,s4,s5)i want to execute first 4 session after 5th session how will you do?
What are Business Components in Informatica?
What are some examples of informatica etl programs?
what are the Methods For Creating Reusable Transformations?
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
Teradata 
