DSXchange

Hi, here I have to develop a job so that I have to load the target datawarehouse with the 3 years history. Once it happens I need to upsert the warehouse monthly with the new data. here I would like to use startdate and end date as the parameters for determining the data extracted from database. Is ...

Hi,
here my question is what is the size of a variable a datastage can handle is there any limit such as 32 bit or 64 bit. I studied somewhere that Datastage 7.5 can handle upto a max of 32 bit.

Thanks
Kavuri

Hi experts,
Is there any difference between environment variables and job parameters? Please explain me.

Thanks in advance

Kavuri

Hi experts, I would like to desig a job which needs to take run time parameters. Can anybody give me a hint at what stage in designing I need to set the options. for example suppose if I am reading DB2 files from DB2 server and I am having various tables need to be converted into text files through ...

Hi ,
can anybody explain me what is the difference between Datastage DB2/UDB Enterprise stage and datastage DB2/UDB API stage and DB2/UDB Load stage. In what situations which need to be utilised.

Thanks in advance

kavuri

Hi Bryceson, I am studying a lot I am unable to decide what to use may be I know the things on practice. Thanks for your suggestion. Here I found a link "http://www.ibm.com/developerworks/db2/library/techarticle/dm-0609xu/index.html" . Can you please tell me this gives me a correct solutio...

Hi,
I am getting input as 64bit data from a DB2 database and I need to convert it into 32bit into the text file. What stage is good to use modify stage or transformer stage or anyhting else is there.

Thanks in advance.

Kavuri

Hi, here I am having 6 boxes and each box contains 8 processors. My DB2 data is distributed among these boxes. I have to extract the data from DB2 tables and do some transformations and load back into same boxes in text format. My question here is do I need any plug-in to extract the data from DB2 d...