DSXchange

How to get report on list of every user with their roles / access by server on 8.5 datastage version.

Anybody know any utility or script or report to pull.

Hi All, I got below requirement to immplement in datastage. please let me know how to implement. Help is appriciated. (SALE_DT - In service_DT in days) / 30) rounded to next 3 months increment Sale Date: 1/15/2009 and In service Date: 5/7/2008, the Age is 253 days / 30 = 8.43 months rounded to next ...

Please could you explain in detail?

If a column is nullable from oracle source and loading in to target data set is also nullable but still the records were dropping . Why are the records were dropping if the column is set as nullable?

APT_CombinedOperatorController,0: Field 'PUR_DATE' from input dataset '0' is NULL. Record dropped.

Thank you for your reply.

I have done in privious projects and thats what our manager suggested that writing long user defined queries overhead the DB.

but here we don't have choice to implement our ideas in designing the ETLs.

Hi Ray, What is the best practice for using the datastage tool (like join or lookup stage )or just writing the user defined queries in data stage oracle stage and just load the database? our lead told us not use the join stage or any other stage just write query and just upload to oracle stage to lo...

Hi All, We are running ETL jobs through dsJobrun.ksh script through unix box not from the datastage client. ETL designs as in multi instance. While running the ETL job from script through unix , the performace Statistics not showing in designer tool. How to see the performance statastics? any help w...

Hi All, I created a job parameters through shared connection and not from add envorinment variable through Administrator. I exported jobs from Dev to Test option using 'Export jobs with excutables' and I ran the jobs in Test. When I see the log for parameters its picking up the Dev parameters not Te...

[quote="srao"]hi , I have a req to capture insert, update and delete so I used change capture stage to achieve. I created three different links to insert, update and delete for same table. Does it create any issues like database/table locks while performing insert/update/delete? if so what...

hi , I have a req to capture insert, update and delete so I used change capture stage to achieve. I created three different links to insert, update and delete for same table. Does it create any issues like database/table locks while performing insert/update/delete? if so what are other options ? I a...

Hi All,

I have requirement Many-to-One: computed field. How to achive in datastage? Thank you for help.

Many colums to one column field.

Hi ,

disable primary constraints before loading data and enable constraints after loading data in oracle. How we can achieve in data stage?

Hi,

I need to populate the time dimension using below columns. How to achieve in datastage ? any help please

Calendar year
Calendar Quarter
Calendar Month
Calendar Mth
Fiscal Quarter

First clear the log for particular job and then reset the job . then it worked fine for me. Try

Hi All, I have Oracle 10g database and which stage is better to connect? DRS stage or Oracle Enterprise ? I felt better using DRS stage because there are many options in DRS stage. for ex: if I am using join stage then the keys columns should be same as in both tables if not then I can use derivatio...