DSXchange

Hi Can you please let me know how to connect to Oracle Using Oracle Enterprise Stage? Case: Name of the Host : X Name of hte Oracle Server : Y TNS Service Name (ODBC) : Z User Name : u Passwprd : p Now, please let me know using this information how can i connect to oracle using oracle Enterprise Sta...

Hi Can you please let me know how to connect to Oracle Using Oracle Enterprise Stage? Case: Name of the Host : X Name of hte Oracle Server : Y TNS Service Name (ODBC) : Z User Name : u Passwprd : p Now, please let me know using this information how can i connect to oracle using oracle Enterprise Sta...

Hi, My current job has a source as ORACLE and after applying business logic, I am creating four extract files. (Sequential files).This job is scheduled on production and working nicely from last six months. Now the business requirement has been changed and instead of ORACLE source, I have to use syb...

Hi Can you please let know how to implement the logic of Transaction Control Transformation of informatica in DataStage? Details About Transaction Control: Informatica allows you to control commit and rollback transactions based on a set of rows that pass through a Transaction Control transformation...

Thanks for your valuable information.

Hey Thanks for the reply and yes we can do it using the External Stage and the script. I was thinking to take "FILE NAME" from input row in a PARAMETER and COMPARE it with PREVIOUS "FILE NAME" and depending on the result we can either create a file or write a file. In short I was...

Hi We are seeking a solution to create multiple output files depending on the input data. Our input row has a column "File Name" which has different values. Using that values we want to create out put files. If that file name already exists then write into the file else create file and wri...