DSXchange

Hello, I have created a job design where I am passing the SQLStatement at run time. The SQL script file is kept at Unix. The SQL statement is select name,ID,DOJ from Table1 where Name <>\'Rahul\' and DOJ= TO_DATE(\'01/01/2009\', \'MM/DD/YYYY\') My job is aborting with the below mentioned Director lo...

Due to some restrictions, we are not able to update the TNSNAmes.ora and using ODBC stage.

Hello, I am using ODBC stage to extract the Data from Oracle and Job is RCP enabled. No Metadata defined.. The source table is having approx.30 columns and hacing 3.5 milliion records. My Job is running very slow extraction 300 records per second. Is there any environment variable which I can use wh...

Hello, We are planning to use InfoSphere CDC for Oracle as source and target is also Oracle. Have got an idea about what are configurations need to be done once the tool is installed but could not find any material explaining the tools that need to be installed on Source Database like Agents etc. an...

Hello, Thanks a lot for the reply. I was undergoing some of the post and found that Multi Client Manager can be used to install multiple version of DataStage on the same machine. But this option will not work when we have 2 different project accessing different version of DataStage(one project ascce...

Hello, We are planning to install DataStage 8.7 client on Citrix to be accessed remotely but the issue is we already have DataStage 8.5 installed and being currently accessed by another project. Will DataStage Client 8.7 installation have any impact on the DataStage 8.5 client. I believe we can have...

Hi,

We can say for the intial release, plan is to get the data near to real time and in the next release it should be real time.

I hope I answer your question.

Regards
neeraj

Hello, There is a requirement that we need to extract the real time data available in OSI PI system and generate the files which would be used by business for analysis. We need to extract data after every 20 minutes from the source system i.e. OSI PI. Request you all to please let me know which opti...

Hello,

Got a high level information that we need to connect, extract the data from Maximo and GIS and load it into Oracle.

Request you to please let me know which Stage we need to use to connect to maximo and GIS.

Incase there is any documentation , please share the link.

Regards
Neeraj

The source is cab file and target is teradata. I tried couple of date functions I. The transformer stage but could not get the expected results.. Request you to plz help..

Yes.. I want round it to next possible level

Hello, I need your help in resolving the timestamp issue being faced in my project. If the Microsecond is more that 499 then time should be incremented by 1 as mentioned in the below example Input------------------------------> Expected OUTPUT 2010-01-01 11:59:59.501--------->2010-01- 02 12:00:00 20...

Hi, We are migrating the code developed in datstage 8.1 to datastage 8.7 version. And observded that empty strng handling is not working correctly in 8.7 which worked fine in 8.1 verion of the code. Job Design : (TDCONN1) ---->> JOIN ---->> TFM ---->> TDCNN ........................... | LEFT OUTER J...

Thanks for the reply. We have used the user variable activity stage and able to read the env variables.

Hello, I have 50 Cobol copy books(EBCDIC Format) that need to be populated into Teradata with minimal Transformation. The Job design would be CFF ----> Modify/Transformer--->TD One option is to create the 50 Datastage Jobs(read and load). But I am looking for some generic option Like create Multiins...