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

Q. We are the loading the table on daily basis it is incremental loading. and A person rahul slary was 10000, so if i check before run my salalr is 10000. but toay there is update that my sal is 15k but that will come to know after the load. braod crtiteria is we donot want to show downstream teams partial updated data. need aproad as etl developer

0 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?

0 Answers  

If you have 10 mappings designed and you need to implement some chages (may be in existing mapping or new mapping need to be designed) then how much time it takes from easier to complex?

1 Answers  

How union transformation is active ?

2 Answers   Puma,

How to fix the etl bugs..Tell me the process?

1 Answers   IBM,

hi,there is a scenario like. there are three columns empid,salmonth, sal contains the values 101,jan,1000 101 feb 1000 like twelve rows are there then my required out put is like contains 13 columns empid jan feb marc.......dec and the velues are 101 1000 1000 1000 like this . thank you

5 Answers   Patni,

Hi I'm new in Informatica. Can you show me a mapping sample on how to piviot the records? Thanks Robin

1 Answers  

I have table name in that I have Rajesh Reshika Priya I want the result Like only Starting with R Rajesh Reshika Can someone help me to get these results and How?

3 Answers  

difference between repository database and repository service?

0 Answers  

why we use materialized view over view?

1 Answers   Zensar,

What is active and passive transformation?

10 Answers  

write sql query following table quarter sales q1 1000 q1 2000 q1 3000 q1 4000 q2 5000 q2 6000 q2 7000 q2 8000 q3 1000 q3 2000 q3 3000 q3 4000 q4 5000 q4 6000 q4 7000 q4 8000 i want the output format like q1 q2 q3 q4 1000 5000 1000 5000 2000 6000 2000 6000 3000 7000 3000 7000 4000 8000 4000 8000

5 Answers   CTS,