Interested to Buy Any Domain ? << Click Here >> for more details...
I have the input file as
col1 col2 col3
3 2 1
7 6 8
I should get the output as
col1 col2 col3
1 2 3
6 7 8 ....What is the logic to get this? Is there any
transformation which sorts row wise ? If not how to sort
the incoming records row wise?
- 5 Answers
- 10101 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / vishnu
there is no need to use specific transformation to do
this...
Simply connect the ports like.....Col1---
>col3,col2.....>col2 and col3......>col1 then u wil get the
result...any issues let me know
| Is This Answer Correct ? | 5 Yes | 4 No |
Answer / ankit kansal
You have to use an expression transformation and have two create three variables and output ports and have to write IIF() conditions for all three columns to achieve your desired order.
http://deepinopensource.blogspot.in/
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / pavana
we can sort row wise by using expression transformation .
But the logic to sort must be implemented.by having few
variable ports...
Let me know if there is any other way to sort row wise.
Mr Raja
u can be quite if u dont know the answers. At least others
will answer.
| Is This Answer Correct ? | 1 Yes | 2 No |
Answer / vidyasagar
u can try this:)
src>> Normalizer>> sorter by asc>> Normalizer>> TgT
Regards:
Vidyasagar
| Is This Answer Correct ? | 1 Yes | 4 No |
normalizer transformation
What are the advantages of informatica?
Please let me know how to make Data masking in informatica..
How do you migrate data from one environment to another?
we have table like cust_id,cust_name,cust_loc like this 1.we need to get perticular location,to do this we can use filter transformatin,that logic is same for relation table and flat file tabl?
In which scenario did u used Mapping variable?
Which transformation should we use to normalize the COBOL and relational sources?
4 Answers DELL, IBM, Lehman Brothers,
what is size of u r database?
is it reqire primary key and foreign key relation ship to join relational databases?if yes? explain?
how to join the two flatfiles using the joiner t/r if there is no matching port?
How to start a workflow using pmcmd command?
What is meant by lookup transformation? Explain the types of lookup transformation?
Teradata 
