DSXchange

search for 'double quotes' in dsxchange.

Thanks
samba

How to find the jobs are currently running on Unix Server. Is it possible to get the list of jobs running on server.

Thanks in Advance

In one of the stage variable i am using SetNull(), may be this is causing problem.....

Thanks

I got questions with a job which is developed in DEV env and able to successfully run the job in Development. Now when I exported the job into test envinorment, I am able to compile the job with my user name but my dsadm is not able to compile it. Could anybody help me with this situation. The follo...

Thanks Ray and the bird

Its not inner join and length is not fixed in source table and lookup table.

This is the output i got it. your also expecting same right "Date2","NAME1","Address12" "Date2","NAME2","Address22" "Date2","NAME3","Address31 " "Date1","NAME1","Address11" "D...

Yes in parallel job it self just now only i did it, i got the output as you expected file -----> transform stage(Hard code the columns names) NAME1 NAME2 NAME3 after that your input columns date 1 column address11 column address21 column address31 column next pivot stage output you need to do like t...

sonia,

You can do it like this, Source file/table after that transformer hardcode the column names in that transformer and use the pivot stage.


source -----> transform -------> pivot stage ----->

Thanks

Thanks guys........for your help i got the result what i am expecting..

I need to convert rows into columns. my scenario like this item01 item02 item03 item04 mul01 mul02 mul03 mul 04 EA MI LO XE 12 32 23 13 need to like this sqno item mul 01 EA 12 02 MI 32 03 LO 23 04 XE 13 like that i have to convert 100 rows into columns Can any please suggest me. Thanks in advance

there is no flag column in the target.
only source column has flag.

If the source column = 'Y' i need to populate date in target column.

Thanks in Advance
Samba

In my source table i have flag column it contains "Y" or "Null" If Source column = 'Y' i need to set CurrentDate() Else SetNull() Today i populate data into the target column with currentdate(20060918) where source column = 'Y'. when i try to extract data tomorrow same row will c...

what is the difference between change capture and difference???
when used change capture and difference stage i am getting same output.



Thanks

I am also faced with same problem before...
same exact problem i got couple of months back.
we increase the buffer size.(i dont know how to increase the buffer size)
and after that we never faced that problem.

Thanks

you can use ODBC or Dynamic RDBMS stage to load the into MS SQL Server.

Thanks
samba