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
- 9114 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
What are the tasks that can be performed using sq?
Explain the etl program with few examples.
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
How to join three sources using joiner?
Explain sessions and how many types of sessions are there?
What is transformation?
Can we get 1st record through Informatica(without sequence number).
What is domain in terms of informatica?
What is resilience time?
Global and Local shortcuts. Advantages.
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
When do you use sql override in a lookup transformation?
what is degenerated dimension?
How identifying bottlenecks in various components of informatica and resolving them?
