DSXchange

Hi , I tried to see the menu once the Datastage server is installed in the Windows 2000 Server box. I am able to see only Datastage package installer. Apart from that nothing in the start menu. Keeping this in hand how can i import the jobs in the Datastage server. I have a DSX file (contains the j...

Hi,

Take a stage variable v, assign a value to it i.e in u r case max number. Take another variable v1 and in the derivation set v1=v+1.
then use v1 for u r sequence. i guess this will work.

If not experts can correct me...

Hi, i have a small idea about scd 2 will you try this once.. target l l look up(hash file) l l transformer----------------- target l source take 3 instences of the same target. first one for update existing row(expiry date) second for insert new record. third for insert updtated record. Expert s can...

Hi, Lacking info I decided to move this post to the server forum, though this answer will apply to a PX job as well. On top of what was said already: What exactly do you need? A dump of a particular log you wish to save manualy? (Print via the ds Director will do) After each run save the job log in...

u can use Call procedure from OCI before or after.

1stpoint wrote:Like MetaStage, QualityStage, etc. It's a separate product. I don't know if it's included in DataStage Enterprise or not.

it is not included in DS enterprise. we have to get it separately.

thanks tom

hai,
i had imported metadata of a table from oracle with plug in metadata def..
now my table definition is changed. now what will be my solution..
Should i re-import it or any other way.. Can any body help on this..

Thank Q,

Hai all,
I want the job log, which is generated when a job is run, into a file.
Can any body help me in doing this.

Thanks,
S K Reddy

u can user an function
iconv(date() ,'d ymd')

Give me an idea on Hash partition with an example :D :D