DSXchange

Hi Guys

Thanks

After clearing huge DataStage logs, main sequence finished execution quicker on time


Regards,
Suresh

Yes, definitely. The job may technically finish but could be writing records to their logs for all that time. Simple enough to check - purge them and let us know. ... Thanks, will do the purging and keep you guys informed However can you please provide some information on how DataStage upon complet...

Can you cut and paste the sequence log. Even if your PH is almost full, waiting for hours is bit too much. Include a dummy echo statement between J1 and J2 to see when it is triggered. It will ... Dear All.... The snaphshot of director log looks like below- 7/14/2009 8:11:35 AM seq_Extract_dsd_CBJ ...

Dear friends,

Can you please advice how can we enable "COMMIT ROWS" option [meaning perform COMMIT after few set of records] in Informix Enterprise Stage.

Regards,
Suresh

Hi, There is table defined in Informix DB havinb column defined with data-type as "Datetime year to month" i.e data expected in format "YYYY-MM" I want to load this table using Informix Enterprise stage, but I am facing various issues during load due to datatype in-compatibility ...

Dear All, I am trying to load data using Oracle Enterprise Stage into a target table [having Primary keys., indexes and partitions] During the load , i used the upsert functionality based on Primary KEy columns. I tried loading intially say 50 records, the jobs loads initial say 40 records but rejec...

Dear All, I am using Informix Enterprise Stage in a PX job [ETL job designed in REGION-A] to load data into target Informix Database located [REGION -B]. In the Informix Enterprise Stage, Conenction Method used is Native , DB Name is provided and Remote Server is set to FALSE. Whenever this job is r...

Hi All, I created a sequential file with Line Termination set as Unix Style(LF) in Stage-General tab of the sequential file stage. Next I use unix script to fragment this file based upon some bussiness rules to prepare fragmented out files. These files are currently in same format (Unix Style)) My r...