DSXchange

We have a Oracle Data Warehouse of around 100GB. We have to create an ETL Process to extract specific data from this Data Warehouse, and populate into a Data Mart. We propose to use DataStage 7.0 as our ETL tool. Can someone help us with what kind of licence of DataStage should be go for, and what w...

You can search the forum.
This has been discussed earlier.

Kim has given wonderfull tricks with TCL , doing so.

Regards,
Manoj

Thanks Ray...!!

How to define a link as a reject link.....??
I mean how datastage will understand that a link is a reject link..!!

I know how to do this using a constraint , how to use Reject link ?
Would you mind sharing it with me...??

Regards,
Manoj

Devashish, These things will not work. Transaction logs has a tendency to log every transaction taking place on the database. I am giving you two solutions that work very well. 1) You truncate the transaction log of the database ,before running your transaction and change the recovery option to not ...

Dear Wang, Make sure that if you are using CAST function before inserting into the SQL DB , you specify the field length as well. When field length is not specified with the CAST function, the default length is 30. It is just a thought that you might be facing this problem I faced once 4-5 yrs back....

HI All,

Does anyone have experience migrating DS jobs from Version 5 to version 7?
What kind of rework is required?
What are the steps needed?

At the time of upgrading does this actually recompiles all the jobs?

Regards,
Manoj.

There is no bug. Value 0 represents that procedure has run successfully. You are setting a CLOB datatype as an output parameter to show the XML, or it is recordset...?? Anytime using DataStage's XML stage is the best bet. But you can try out setting an out put parameter of CLOB datatype containing r...

Hi, According to my limited knowledge of SQL Server , bulk load drops the constraints if any ,on the object you are trying to insert data. Then it inserts data and recreate the constraints. Although, shrink database command does not lock the object,but probably it wont be allowing you to alter the t...

Hi, I have a question just for the sake of curiosity and knowlwdge. Suppose I have populated my fact table and dimension tables using a set of datastage jobs. What should I do to to refresh my DW in future ? I mean if I want to load the data that is only new and that was not there in the source last...

Hi,
I have seen people talking about sending email when job is successfull,
I am afraid I could see only the net send option for a perticular server job.

How DS can be configured to send email showing job's success.

Thanks.

Regards,
Manoj.

It is not PARROT it is..
Perot Systems.....!!

If you are talking about me...!!

Manoj.

Hi , I am new user of DataStage and learning DataStage doing tutorials and all. I was doing some R & D with the tool and messed up with things, Now the problem I faced was I was unable to connect to that particular project I was working " DEV ", giving an error as follows : Failed to c...