DSXchange

Gentleman
Thank you for the advice. Appreciate it.

Babu

Hi Thanks for the reply. The problem is we donot have quality stage. I have to do this just with Datastage 6. Any suggestions in this regard are welcome. Babu Babbu, the QS will work pretty good for your requirement as Ray mentioned. You can even make this thing a QS only case unless you want to str...

Ray Thank you for the reply. I was wondering if there was a way for capturing duplicate records when source and target are flat files. Thanks Bob You could pass the data through a QualityStage UNDUP operation. A hashed file is a good way to remove duplicates based on key value, but is not appropriat...

Hi I was wondering whether there is a way to take out duplicate records in a flat file. The logic basically should be to error out all the duplicate records based on a key and pass unique records to oracle. Logic Flat file ------>identify duplicates-----> unique records to oracle | | V hash file wit...

Hi I am having a problem implementing a logic. I have a fixed width flat file which has Customer, Account,Group and Product IDs (all characters) as columns. Firstly I would like to reject all records which have any of these values as Null. Secondly I have to see that a concatenation of these 4 value...

Hi I have some data coming from VMS systems and to be loaded into a flat file. The data has header and detail information. I would like to do some computations with the data, like find out the total of all values in detail and compare with th total in header. I know that data in sequential flat file...

Hi I am working with a DS job responsible for loading data into the dimension table. I have noticed that of the 15000 records that have to be loaded only 5000 have been loaded as the job aborted prematurely. Is there a way to start loading data from 5001 record (without the need to drop the initial ...

Hi
I am new to parallel environment. I am interested in knowing how to implement pipeline, partition and departitioning using parallel extender.
Please suggest

Hi
I woud like to know how one performs testing of the jobs created with DS. What kinds of testing can be done and how?
Please inform.
Bob

Hi I am interested in automating some of the jobs I have created using designer. I know that we can export the project as .dsx files but do not know how to automate running the jobs at a set time...say 10:00pm every monday. What is the extension of the job/container/job sequence files created in DS....

I doubt it. :wink: Don't remember that even being mentioned as part of 7.5. Have you tried pointing DataStage's $ORACLE_HOME environment variable to a 9i client and then using the 9i client via an OCI9 stage to access the 10g database? Does that work? It's an old trick I've used before when 9i was ...

ketfos wrote:Hi,
Can you specify what errors/messages you encounter while trying to retreive the data?

Ketfos

The error says that Oracle client and networking components have not been found and need to be installed. These components are present in7.3 version and later.

Hi
I am trying to use Oracle 1og database with datastage 7. I am having difficulties in retrieving date using odbc or native oracle drivers. Any suggestions? (I only have 8i,9i,OCI drivers installed)

Hi
I was trying to fill all the null values in a Oracle table with # sign which is the default setting in DS designer. But once i run and look at the output in the oracle table the table still displays null values. I dont know whats wrong.Is there a way to do this?

Hi
I am looking for DS training material. Can anyone suggest websites or material they can share.
Inaddition does datastage have a demo version to download. Please inform.
Thanks