DSXchange

Hi, I have a query which selects data from Oracle database. I have used OCI stage in datastage server job and write the data to a file. I have 3 different environments- Production, Development and UAT. I am gettign 3 different run time statistics for same query. I production job is taking 2 hours to...

Hi Rivaj, As ArndW said we can use template and create 100 jobs using a job or program. Hi Andrw, can you suggest how to proceed on. Has any one implimented same before. Me and Rivaj are working for same problem? If there is an metadata change after generating 100 jobs how can we go and chage again....

Hi, I have an issue which came up suddenly in between my work. I was working on one project dwhproject3, designing jobs(Not triggered any job in backend). suddenly i started getting error Error calling subroutine: DSR_PROJECT (Action=1); check DataStage is set up correctly in project dwhdrop3stgdev ...

Can i download it from net freely

HI,
Can you help me like how and from where i can download web services pack, my default installation does not contain this service

Thanx in Advance,
Dilip

Hi,
From where i can download Datastage web services pack. my default installation does not contain web services pack.

Hi Sam,
I am using windows OS. i am not getting about the compiler ?

Hi, I have installed Datastage enterprise edition . i created parallel job with simple input stage, transformer and output stage. when i am compiling i am getting transformer error. Is there any settings has to be done after installation. i heard we have to set some config file properties ? If i cre...

Thank you ray. I implemented with unix command LS

Hi, I am using Folder stage to read the file names but the output is comming as blank. I have 2 files in particular folder. when i run the job, it is showing 2 rows have been processed but the output is blank. In the director i am able to see warning message: DataStage Job 1171 Phantom 8454 Program ...

Hi, Sorry for not giving clear picture of the problem. I am using input as XML source file. Current run it has 4 columns : ID, Name, Age, Address. I will process this . In the next run i will get 5 columns(Metadata change) : ID, Name, Age, Address1, Address2. How can i handle this situation. Since i...

Hi, Sorry for not giving clear picture of the problem. I am using input as XML source file. Current run it has 4 columns : ID, Name, Age, Address. I will process this . In the next run i will get 5 columns(Metadata change) : ID, Name, Age, Address1, Address2. How can i handle this situation. Since i...

Hi, From source itself i will be getting different metadata for each run. I have to handle this in ETL not in database tables. Is there any way to handle automatically different metadata in each run atomatically through ETL job. i heard it is possible by using XML stage. Can you suggest me on this. ...

Please refer online documents

From source i am geeting stream data. Data from source will come with different metadata. I have to handle it automatically by creating tables at run time.