DSXchange

Hi,

Can we use hints in SQL query in OCI stage? If I specify a parallel hint for a select query (which does a full table scan),will datastage read faster?

Regards,
Ayan

There is another property called Transaction size. I understand this number defines the Commit Interval and should not be too small .But does it have any correlation with array size like transaction size should be multiple of array size or something?

Folks, I am devoloping a job which reads from oracle via oci stage .When I tried to configure the OCI stage I found these two prroperties called array size and prefetch memory setting.Could you please help me to undestand the exact significance of these two properties? Array size is 1 by default.Sho...

Well,I can see your point.Another question,can I mention IP in the -server option?

Hi, I am writing a shell script which will check various conditions and then trigger the master sequence. Now if this script is run in the datastage box through the datastage login, do I still need to mention server, user, password in the DSJob call ? I guess not... But want to confirm it once. Rega...

The problem got resolved.Actually I was constructing thescript call dynamically within the routine and setting the variable 'cmd'.The pathname of the script was getting populated incorrectly.Rectified that.Routine is working fine now.Thanks to you all for providing suggessions.

Regards,
Ayan

Guys,thanks for your inputs.Actually the problem is not with relative or absolute path name of trigger file.I should have provided more information in the first post itself.Here is what I am trying to do : This after job sub routine captures the job statistics like start time ,end time,status etc.Ne...

I actually looked for the trigger file in $DSHOME path.Should I look into someplace else?

I am trying to run a shell script from after job subroutine without much success.I have crosschecked that the shell script statement is correct.Following is a code snippet : cmd='touch mytest.trg' Call DSExecute('UNIX',Cmd,Output,ReturnCode) Call DSLogInfo ( "Audit Routine Returns ":Return...

Yes,that works.So is that the only option?Any GUI alternative?

While exporting and importing a job,I have always noticed that the folder information is included in the .dsx file and if the folder is not present in the target project (where the job is being imported),it is created.Now if I want to import a job to a different folder (say a job is in folder X in D...

Ok,will set it in Administrator. Ray,it works.I was able to load it in oracle db(10G).Only problem I faced is that ,while querying toad I wsa not able to see the chinese data.But after using sql developer/isqlplus,data was getting correctly displayed.Don't know whether it's a toad problem or any ext...

Hi, I have a job that loads chinese data in oracle 10g db.For the loading to happen correctly I need to set the NLS_LANG value in datastage box to AMERICAN_AMERICA.AL32UTF8.I know that it can be done in a script i.e I set NLS_LANG for that session and call the job using DSJOB.But is there a way to d...

Could anybody please give me some idea about what are the salient security features that datastage server version has?I actually need to come up with a small presentation to the client.What I can think of at present is that 1)client level authentication 2)server level authentication 3)password value...

Yes..did just that..working...Thanks.