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?
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
What is the function of look up transformation?
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
What do you mean incremental aggregation?
As union transformation gives UNION ALL output, how you will get the UNION output?
Explain about cumulative Sum or moving sum?
How you can differentiate between connected lookup and unconnected lookup?
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
How many input parameters can exist in an unconnected lookup?
Describe expression transformation?
What are the mapping parameters and mapping variables?
What is dimensional table? Explain the different dimensions.
How do you load only null records into target? Explain through mapping flow.
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
In which transformation you cannot drag ports into it?
Please let me know how to make Data masking in informatica..