DSXchange

Hi Chullet, Thanks for your kind reply. As you had said I had set APT_ORA_UPSERT_COMMIT_TIME_INTERVAL to 5000 seconds and APT_ORA_UPSERT_COMMIT_ROW_INTERVAL to 0. I had ran the job and while the job was running I had queried the table in the oracle sql plus and count(*) was always returning 0 provin...

Hi Guys,

Kindly reply and help me out pls....


Thanks in advance...

Vikram.

Hello Guys, I am new to datastage. My target DB is oracle. My requirement is to rollback changes made to the Database when the job aborts in the middle (for dimension load alone). (I am using oracle enterprise stage with upsert option) What I did was , I had set APT_ORA_UPSERT_COMMIT_ROW_INTERVAL to...

Hi Guys, Thanks for your kind reply. I am using sort stage since i want the data to be sorted when it reaches the oracle destination stage. If lookup and transformer stages don't change the sort order, then why there is an option called " PRESERVE SORT ORDER " in transformer stage ??? Kind...

Hi Guys, I am new to datastage. I am trying to migrate a job from SSIS 2005 to Datastage. My parallel job design is , Oracle Src --> Sort ---> Lookup -----> Transformer ---> Oracle DST. In the sort stage , I am doing a hash partition based on a Code column and sorting based on Code and Date Column. ...

Hi Ray,

Thanks for ur reply....

Thanks to dsxchange.

Regards,
Vikram.

Hello Guys, I am new to datastage. I am trying to migrate a job from SSIS to Datastage. The job is really simple just a one to one mapping from source to target. Source data has two columns - Name varchar(100) , Age integer. Target Metadata - Name varchar(10) , Age Integer. I used a transformer to d...

Hi suse_dk,


Thanks for helping me out....


Regards,
Vikram

Hi Guys, I am new to datastage. I am trying to migrate a job from SSIS to datastage. In SSIS lookup there are two option called Full Cache and No cache. Full Cache : Reference query will be fired in the beginning and will be stored in the cache. No Cache : Reference query will be fired for each inpu...

Hello Guys ,
Thanks for your kind reply.

Change capture stage doesnt support duplicate keys even if the input data is sorted.

Thanks again,

Vikram.

Hi Guys, I am new to Datastage. I am doing some POC's on change capture stage. I had tried the following example using Change capture stage. Before Dataset, Code Name P1 A P2 B After Dataset Code Name P1 C P2 B P1 D key column is Code and change value is Name. ResultSet Code Name ChangeCode P1 C 3 (...

This is the only error message i am getting...there are absolutely no warnings....I am just getting " Unable to insert records :...thats all...

Hello Guys, While loading data into the staging table , I am getting the following error, "Unable to Insert Records" Total records in the source is about 2 lakhs. After some 80000 records are loaded into the staging table , I am getting the above error..... My target DB is oracle and I am ...

Hi Guys,

I had changed the preserve partitioning to clear and sort2 began working fine.

Hi Pandeesh , Thanks for ur reply. Actually the time part is also included in date part ( Sorry for missing out time part in the previous posts ). The actual source data looks like this P1 ABC 01/01/11 00:00:00 P1 BCD 01/01/11 00:00:00 P1 CDE 01/01/11 00:00:00 P2 AAA 02/01/11 11:00:00 P2 AAA 02/01/1...