DSXchange

Hi Ray, As you said i already did ,im able to take max value(Latest date and Max sequence_No) from Hash file, but im not able to pass these columns into Transformer,since these are individual columns. Since im using Sever job i cannot use Column Generator Stage. ODBC(SOurce)--------->TRNSFORMER-----...

Hi, I have Audit table which maintains Run History.Using same job im loading data into ODS table and Audit table.Audit table has two extra columns than my ODS table,i.e Loaded Date and Sequence_No. First time when i load the data Sequence_No is 1, when i load the data second time it has to check the...

Hi, I installed Datastage on my PC(both cleint and Server) OS is Windows XP Professional. I got same error which u got exactly. RPC Daemon is not running error 81016. I can open Designer and Director.But im not able to open Administrator and Manager. Tell me how you resolved this issue. Thanks Vbeeram

Hi, I installed Datastage7.1r1(Server Edition) on Solaris,successfully installed. But i have UDB DB2 source on AIX machine. I am not able to connect UDB(on AIX) from Datastage(Solaris). I am using following .odbc.ini and uvodbc.config files. bolded fields iam filling as per my available details. Any...

Hi All,

I am using Datastage EE(7.1),i need to extract the data from Multi Dimensional Cube(built in Sybase).Is Datastage has capability to extract data directly from a Cube?

Any ideas....


Thanks in advance,
Beeram

You can call as Before/After Sub Routines

Hi Brad,

bcaz i have 360 conditions and 360 columns,it's compulsory to check condition and pass the O/P for corresponding O/P column.

If i use Transformer also expensive bcaz i need to check 360 conditions in Transformer.Performance point of view i'm using SQL query.


Thanks
Beeram

Hi Brad, Sinece my Team decided to not to use Views/Procedure,i have option using splitting the job into two parts,this already i implimented.Other than this is there any way to do this. This query is like all Case Statements,i have 360 Input columns so for each column i have condition and calculati...

Hi,

I have a SQL query which is nearly 360 lines,i am writing in DB2 Enterprise stage but it's accepting only 120 lines of SQL query.

So any body's idea about this?
It's urgent.


Thanks in advance
Beeram

Hi,

Yours source column must be String type i.e varchar
You also specify the I/P Source format.

Syntax: StringToDate(Column,"source column format ")

In your case
ex:StringToDate(DateLiknk.Date1,"%yyyy%mm%dd")

This will work.

Rgds
Thiru

You dont require UNIX while learning Datastage,just to run and schedule you can use scripts.

Also some commands useful grep,sed and awk for String manipulations.

Check the name,data type and length of stage variable .

Hi,

Where can I find white papers or literature about the conection process between DataStage 7.x and PeopleSoft EPM?

Any body know abt this connectivity?


Thanks
Vbeeram

When u use sequential file stage,define the value for nullable field.
For that double click on that column (u get edit column Metadata editor)there specify the null field value.

handle the null vals properly(use default valus) and check the metadata.


Regards
vBeeram