DSXchange

Thanks for the reply,
I am using RCP where ever I can.

Thanks and regards,
Munish

Hi All, Is any one aware of any utility in Datastage which could help us in dynamically changing the schema in all the stages if the Table Definition, which those stages are using, is changed. To explain it further, We have build end to end ETL with some 70 different jobs with around 1000 stages. No...

Thanks Everyone,
I got the answers.
Closing the thread.
Regards,
Munish

Thanks Gentlemen, I deployed them as Executable. However, if someone could throw some more light on 1. I deployed the jobs as Executable with Design Information, When I open that DSX, Some of the DSX have design information with binary information (0,1) WHERE as in others it is Design information wi...

Hi All,
I have to deploy the project with 60 separate jobs into Test env.

Is there any way to use
'Multiple Job Compile' Datastage utility
through unix.

Thanks and regards,
Munish

Thanks Everyone,
It worked fine this time.

I was missing:
I was not passing any record from Row Generator.
We have to make sure that it should be atleast 1.

Thanks again,
Closing the thread,

Regards,
Munish

Hi Everybody, I tried this Stage:Dummy RowGenerator, 0 record >>> OCI:Upsert Mode = User Defined Update Only I have written my own script to update one Column. Script: UPDATE EDX_RPT_ACCOUNT_FACT SET CUST_VIEW_FLAG = 'N' WHERE CUST_VIEW_FLAG = 'Y' This script works fine in Toad but no row is updated...

Thanks Champs,
I got it.
Closing the thread.
Regards,
Munish

My ETL has 40 sequences.
This is going to be the last sequence where once all the prior (40) sequences finishes successfully.
I need to update column in 2 tables in Oracle with value as 'Y' and 'Successful'.

I was just wondering what might be the best way to do it.
Thanks,
Munish

Why not have a job that does this? Why do you 'need' to run sql scripts? How to do that in a single job. OCI stage does not do anything of its own. I need to add another stage to OCI to get that working. Is there a way out. I was thinking of using scripts just to get away with this, otherwise I am ...

Hi All,
I need to
run SQL sripts to update tables in Oracle (Update flag to 'Y')
after successful ETL run.

I want to do in one stage.
What might be best options.
1. Using 'Execute Command' activity.
2. Using Routine.
or
something else.

Thanks for your advice(s) in advance,
Regards,
Munish

Hi All, We need to estimate the virtual memory size (Scratch) for our project. Can anyone provide some guideline or best practice to evaluate that. Do we have any formulas to get those figures. We are assuming that memory size is decided by 1. Input Data size. 2. Number of stages 3. Number of client...

Thanks Ray, Could I please request you to put some more light on Point 2. In application, if I need to run individual job, I have to take care of dependencies. How does this happen in DS, when I import individual job does it takes dependencies like param etc. with it. If not, what else should be imp...

Hi All, Our project is in deployment stage. There are a few doubts I want to clear up, I tried using DSX search and as usual it helped me a lot, however I am left with a few doubts. 1. Can we compile from the command line in a Unix (Solaris) environment? >> I think one can not compile from command l...

Ya, I will catch hold of our DBA.

Thanks,
Munish