DSXchange

Hi, I am using DataStage V5.2.1 running on UNIX. Is it possible to connect to MS Access tables? I dont want to export the Access tables to flat files and then processing. Is there any way to directly ready the MS Access tables (thro ODBC) and populate it to Oracle? Please help me in this regard. Bala

Hi All,

I want to populate the CLOB datatype thro Mapping. Has anyone know whether DataStage supports such datatypes?

Bala

God is an Infinite Circle whose Centre is Everywhere but Circumference is Nowhere

Hi, I have 2 queries regarding job Sequncer in DataStage. 1. How to write a customized Trigger, say for example, it should trigger next job when the job completed successfully or job finished with Warnings. 2. I have 5 jobs say A, B, C, D and E. After the completion of the Job A, the jobs B and C sh...

Thanks for the reply. Is it possible to achieve the same thing thro mappings? Because, our client want everything in terms of mapping and they are not encouraging the coding part. Thanks, Bala We want to design job in such a way that the job has to poll for a table with flag as 'Y'. We are using dat...

We want to design job in such a way that the job has to poll for a table with flag as 'Y'. We are using datastage V5.2. We dont want to spool it in file and then use the WaitforfileActivity. Is it possible to poll for a table? Thanks, Bala Well, if you don't want "time based scheduling" th...

Hi All, I have some doubts in Job sequencing. 1. We want to store the parameters in a common place and all the jobs in a Particular project has to read the values from this common place. We already wrote a program to read from flat file but the requirement is to achieve this without any coding part....

Hi, In my job, the transformer has 2 inputs, one (primary link) from Oracle and the lookup is hashed file (using UV stage). There is no Check box with option "reference link with multi row result set". The datastage version is 5.1. Can anyone please guide me soon. Also, I want to know the ...

Hi, In my job, the transformer has 2 inputs, one (primary link) from Oracle and the lookup is hashed file (using UV stage). There is no Check box with option "reference link with multi row result set". The datastage version is 5.1. Can anyone please guide me soon. Also, I want to know the ...

Can anyone exlain me on conditional lookup??? And how it can be achieved thro DataStage V6?

Thanks,
Bala

Hi All, I have some doubts regarding Hashed File. In Datastage Ver4, Key column is a must in column definition otherwise it will give the message box saying "Key column should be selected" and it wont allow the users to press OK button without key column. But in DataStage Ver 5 and V6, it ...

Can you please elaborate??? Assume I am not using any OS level commands (ExecSh and ExecDOS), then there wont be any problem in migration right???? Suppose, If I use ODBC stage, then what needs to be done to work for new environment??? Anyone please help me on this. Thanks, Bala Yes, with a caveat. ...

Hi All, Is it possible to move the entire projects from Unix (solaris) to AIX platform or Vice versa??? Will all the routines and mappings work without creating any problems??? Because in Informatica, some of the functions will not work when we changed the platform. Is it so in DataStage??? Please h...

Hi,
How can we use Excel to read the parameters?? Suppose, I have 5 jobs and all the jobs has to read the parameters from Excel, then how to implement that? If I want to pass the parameter for the OCI plugin (user name, pass word and DB) from Excel, how to do that?

Thanks,
Bala

Hi,
You can store the passwords and other parameter values in a flat file and Create a Batch job to read the values from this Flat file and pass it as parameters for ur jobs.

Hope this will help

Thanks
Bala

Thanks cmueller. SO, if i want to generate sequence number where there are some constraints in the Transformer, then I have to use @OUTROWNUM. Is this right?

Thanks,
Bala