DSXchange

Hi

I have some tables at oracle need to import to Datastage Repository.
Can pls tell the stpes to be followed.

Thanks & Regds

Hi,

I've a doubt in defining the Array size and transaction size

Suppose if i take array size is 1000 is there any mathematical calculation to define the transaction size or is it optional to choose?

Provided you only want inner or left outer joins, then you can use the conventional lookup mechanism in DataStage, using a Transformer stage. The stream link can come from one data source, the reference input link from the other. Obviously you need to generate a suitable reference key expression, o...

Hi all,

Till now we have developed server jobs in which we used DRS Stages as the source stage, Is there any method to join the tables which are taking from diffrent source databases. if so what is the method.

Can any body tell this pls.

Thank you Love

Hi,

In Datastage Basic Language there is type1 file and type 19 file defined in VOC file can u anybody explain what difference exactly.

Thank you verymuch. In server jobs you use the Transformer stage with one stream input link and other reference input links. The stream input link is delivered a stream of rows from one data source (some joins may have been performed there). Each reference input link connects to another data source ...

In server jobs you use the Transformer stage with one stream input link and other reference input links. The stream input link is delivered a stream of rows from one data source (some joins may have been performed there). Each reference input link connects to another data source and is provided wit...

Hi All,

Can u any body explain how can we do the joins in the Server jobs if the data is to be extracted from multiple sources like Oracle, Sql Server and Sybase,flat files etc.,

Thanks in Advance.

Regds

Hi,

i have a question that is it possible to run a single job in multiple instances , i mean is it possible to run a job in a multithreading way, as of i know if we open same job repeatedly it displays some message like ' Job is using some other person' .

So can u any body clarify this.

Regds

Be sure when you log into DataStage Manager that you DO NOT check the Omit button. Thanks to both Ray and smith, when i was tried to import the jobs without any username and pwd the error occured, after giving the authorized user name and pwd the jobs imported smoothly. Thnks a lot once again. Regds

Hi all ,

while importing one of dsx to a new project iam getting the following error can u any body tell me what might be the problem


Error calling subroutine:DSR_RECORD(Action2):Check Datastage is setup correctly in in Project

Regds

Hi friends,

Some times the serverjobs are getting locked. Can u anybody tell me how to unlock/release the jobs, to do this any admin preveliges required or any user can do. Please clarify.


Regds

Is Joiner Transformation in informatica and Hash file in Datastage can perform the same functionality.And also i have one doubt that hash file will use Hashed algorithem for getting data from the source data.if it is correct can any body explain the fucntionality of the hashed algorithm.


Regds