DSXchange

Hi DataStage Gurus,

Your enlighten inputs / clue are highly appreciated.


Thanks
Elavenil

Hi Ray, The recommended code was modified slightly and transformer stage for the 1st job is written in the file. But it did not go to next job and i think i am missing something. Could someone help to get transformer stage names for all jobs in the project? Code is pasted below. $INCLUDE DSINCLUDE J...

It is working fine after modifying slight changes.

The same code will need to be enhanced to write the jobs' name into a file.

Thanks Ray for your help.

Regards
Elavenil

Thanks Ray for your great help.

Let me test this and i will let you know the outcome soon.

Regards
Elavenil

Thanks ArndW and Ray for your recommendation.

Point noted on DS_TRANSFORMS as this does not provide the info needed.

Where is the recommended code to be written & executed?

I have limited knowledge on the BASIC code recommended.

Your help is greatly appreciated.

Thanks & Regards
Elavenil

Thanks Arnd. The way that you recommended provides no of jobs on which transformers used. For eg. more than one transformer used in the same job, the job is listed. What i need is to get no of transformers used in the project. Is there any best way of getting no of transformers in the project? Regar...

Understand that no of transformers in the project can be determined by querying UNIVERSE tables. please let me know the below query will provide that. select count(*) from DS_TRANSFORMS and this command needs to be executed from Administrator client. Is there any alternative better way of identifyin...

The load job, which loads data (DS --> Teradata table) into Teradata was failed with 'Sync timeout of 999 seconds expired' and it was successful when it was resubmitted. Where is this sync table created? How can this table be checked to identify the symptoms of this issue? Is it due to insufficient ...

Thank you very much for your response.

Let me try this option and i will let you all know how it goes.

I am very sure this option will help us decreasing our batch timings at least 2 to 3 hours.

Regards
Elavenil

Thanks for your response. Template job is used to read input seq file and dataset is created on the same job. The job design is as below. SeqFile --> Column Imp --> transformer --> Dataset. Schema file is used in Col Import stage and RCP is enabled. So while creating dataset, only 'Auto' partition i...

Thanks for your response. Input file is read based on the schema file and RCP is enabled on the same since same template job is used. Hence Columns are not visible to select Key based hash partition (in Partitioning tab) and i do not see any placeholder to choose a parameter. Please help providing m...

Hi, We are using a template job to read input file and create an output datasets. Since template job is used, we will not be able to define partition based on key as key columns will be different for each input file and RCP is enabled in the job. This data needs to be repartitioned in the next job b...

Hi We are encountering some intermittent issues while loading data into Teradata DB. As an investigation process, we would like to enable some trace / logging mechanism to capture TD script to identify the options used in the script. For eg. when MLoad used, what is the MLoad script submitted to Ter...

There is 'Account' option to specify account in Teradata Connector Stage. Is this account same as 'Account String' in Teradata for which priority can be set at Teradata side?

Thanks in advance for your help.

Regards
Elavenil

Thanks Ray for your response.

Understand that ISALite provides comprehensive info to identify the bottleneck of a DataStage issue. But i am trying to collect each and every parameter's value in UVConfig file and Project level environment variables values. Would ISALite help on this?

Regards
Elavenil