Answer / raja

There is no logic for this.You should try to be smart by
asking the useless question.try to ask some question which
will be useful for others.

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

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/

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.

Answer / vidyasagar

u can try this:)

src>> Normalizer>> sorter by asc>> Normalizer>> TgT

Regards:
Vidyasagar

What is joiner transformation?

0 Answers  

my source like dis 10,asd,2000 10,asd,2000 10,asd,2000 20,dsf,3000 20,dsf,3000 20,dsf,3000 like dis and my requirement is first record is inserted into first target and duplicates of first record is inserted into second target ...like dis way ...? how to achieve dis?

4 Answers   Mind Tree, Polaris,

wt is the difference between truncate and delete in which situation u use delete and truncate in real time..

4 Answers   TCS,

what is mapping parameter?

2 Answers   Cap Gemini,

When do you use sql override in a lookup transformation?

0 Answers  

I have Employee table, 10 cols are connected to next transformation, only 4 cols are selected in SQL override. What would be passed to next col.

5 Answers   BirlaSoft,

why we use datawarehouse

0 Answers   HCL,

How can i send first half of the records to one target and Remaining to other target?

10 Answers   TCS,

My questions is i create a two sessions for one mapping.but my requirement is if all number of source records are same as in target then execute first session or some rows are rejected due to t/r logic so session two was execute please clarify

1 Answers   TCS,

I have in my source Records like 100,101,102 etc. I have router transformation which has groups like one group is empno=100, second group is empno>99. Now i want to know my source record 100 loads into which group?

5 Answers   Span Systems,

Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks

0 Answers   Cognizant, IBM,

Performance wise which is better joiner or look up ? Give me with example?

1 Answers   CGI,