DSXchange

Hi All,

How can we just compare two files...and find the differences...
No Inserts and Updates needed...
Any Clue..?

Thanks

No, I cant even view..
The error I sent you is when i clicked on "View data"..If I run it ..It failed...

The error says as follows, it cant open file:

DSD.SEQOpen Failed to open CORAM.TXT in directory so and so
STATUS = 2.
I have specified (,) as delimiter and quote charac as (0)...

Thanks

Hi,

Can I save an excel file as a csv file and use it from Sequential file..? I tried to do so..but the job failed... Pls tell me if there is any way that i can save this file as a Sequential file stage readable..?

Thanks

Hi Sai,

So Irrespective of wat parameters we gave in sub jobs, It will over write from Job Sequencer Parameters list...rt..?

Thanks..

Hi,

Do the Parameters in Job Sequencer Overwrite the parameters in each job..? or Do I need to give the same parameters in all jobs and sequencer...? I used Job Control, I never Used Sequencer..I think it will overwrite but Pls correct me if I am wrong...

Thanks in Advance..

Hi,

May I know in what context we can use Multiple Instances..?

I have a job to look for which is running in Multiple Instances...what we need to specify while running it...at Invocation ID..?

Thanks in Advance...

Perfect ....

Thank you ver much Ray... :D

As you said we can use a database stage or a hashfile stage, how can we specify what kind of join we need...if i give the condition in constraint box in transformer like lnk1.ColA=lnk2.ColA, it will become innerjoin...how about Outer Joins...

Thanks Ray !!! :D

Hi ,

I am a guy of Parallel extender...We are asked to do a server job...I am little bit concerned about doing joins (like Inner Join, left Outer...etc.,) how can we specify the type of joins in server job...?
Can anyone pls hint me..?

Thanks

Hello everybody, can anybody tell me what this error message mean? " Error Calling Subroutine:*DataStage*DSR_SELECT (Action=3): check DataStage is setup correctly in project XXX (The connection is broken (81002)) Is this something that popsup if we dont use datastage for sometime or something r...

Hi Lory, I am giving what I new, I welcome someone with more information on this. 1) In 7x, we have some new stages added like row merger and row splitter etc.. 2) we can copy and paste the stages, jobs in the designer. 3) you can run job in the designer itself. 4) we can compile multiple jobs at a ...

The basic difference between these two is that in BASIC Transformer stage, we can access BASIC transforms, routines and functions as the name itself says.
and the documentation "Parallel Job developer guide" gives you two chapters with clr description.hope that will help you.

Thanks

In The Target Seq file, in the inputs tab, default is set to 'over write existing file',you have to select for second seq file as append existing file.
I think this will do.

Thanks Ray

Abhi