DSXchange

Hi,

I am very much eager to know the internal mechanism when we start compiling a job and Running a job.

i mean the process flow when we start compiling and running a job.

Thanks

Regards
sunshine

Hi,

can someone explain,
what are the Best Practices For ETL Development and Datastage Usage??


Thanks
sunshine

Hi,

how many nodes we can accommodate for one CPU?

is there any fixed number?


Thanks
sunshine

so this is only for premium members..

Hi,

i know how to use multiple instances of job.
(In designer select "Allow Multiple Instances").

but in which scenario we use multiple instances?


Thanks
sunshine

Hi,

Can some one has idea about Multiple Instance of jobs in Data Stage?

Thanks
sunshine

hi,

can someone has idea about
Integrating EDI with datastage for automation of online messages?



regards
sunshine

source table has 8 columns & target table has 9 columns.
gave a dummy value for target table 9th column(i.e surrogate key)

its giving Exception as:

SurrogateKey..Oracle_OCI_9i_6: ORA-01036: illegal variable name/number

[quote="sunshine"]Hi, I created a sequence in oracle. i need to call this sequence/use this sequence inside a column in DatStage. Can someone has idea? it seems there are lot of ways to do this... Thanks Regards sunshine[/quote] I tried using the following query in target database NSERT IN...

Hi,

I created a sequence in oracle.

i need to call this sequence/use this sequence inside a column in DatStage.

Can someone has idea?

it seems there are lot of ways to do this...


Thanks

Regards
sunshine

can someone has idea how to copy a job from one project to another project?

Thanks for your reply


regards
sunshine

[quote="ArndW"]You can certainly give it a go. The best approach to take is: 1. create an empty new project on the new machine with the same name as the original project and with the same absolute path. 2. copy the original project directory and subdirectories to the new machine and make s...

[quote="tombastian"]It happens this way when any of the DataStage Jobs are open in Designer during the REINDEXing process. Make sure that none of the jobs are opened (locked status) before executing this command. You can execute this command once again after making sure that none of the jo...

[quote="chulett"]I've seen that happen if you are not alone in the Project. Are there [b]any[/b] other users or processes accessing that Project? You may need to kill off any 'leftovers' from other folks and try it again.[/quote] Hi, I am alone in the project. i logged as Administrator. i ...

Hi, I executed DS.REINDEX ALL from command line from DataStage Administrator. when i open Designer,after executing DS.REINDEX ALL command, I am UNABLE to see the jobs in Repository Pallette.. Even when i open the Director,its not displaying any jobs.. strange problem.. :( I never faced such a type o...