DSXchange

Ernie, Ray & Arvind, Many thanks for all the suggestion. I have gone through all the IBM and google documentation. I am after a document like cheat sheet (step 1, step2, and so on). If somebaody has developed one while doing DL, DP, DQ, and DT, I would like to take advantage of that (if anybody ...

Hi Harshada,
This is the limitation of the tool. The only way to get around the problem is to break the table into three. You may raise a PMR for enhancement. May be in the future release, they will do something.

Bana

Hi Consultants and Experts, I am in the process of doing the Data lineage and tracing from Cognos report thru Framework Manager, ETL Presentation, Staging and Landing jobs, and Data Model to Source systems. Has anybody done this exercise? If yes, is it possible to share end-to-end steps documentatio...

Hello Experts,
Information Analyzer creates about 64 reports after the profiling completion. I am downloading those reports one-by-one.
Is there any way to download those reports at a time?

Regards,
Bana

I have know more before I can suggest something?

Is it an Oracle partition or DataStage partition? Which type of partition method you are using?

Regards,

Hi All, I don't want to be critical. I have noticed that members or non-memebrs suggest something without understanding a problem, which is not very helpful for a person who raised the issue(s). And then talk about problems, which are completely unrelated. By searching APT_BadAlloc in the forum coul...

Hi All, This not same as previously discussed topics relating to APT_BadAlloc. I have developed a Parallel Job using Oracle Connector as source, lookups, and target. Then added SCD to it. It reads about 5 mil from previous table and compares with source rows (that has 5 mil too). It reads the previo...

Log in as dsadm and run the job and see if you get the error. If you do not get error, then file permission error.

Create a routine to call the script.

The create hash file option allows you to specify how the file is created. There are 2 option where you specify the dynamism of hash file, for instance: file type (Type 30 is dynamic) and hash algorithm (general or SEQ.NUM).javascript:emoticon(':lol:')
Laughing

The create hash file option allows you to specify how the file is created. There are 2 option where you specify the dynamism of hash file, for instance: file type (Type 30 is dynamic) and hash algorithm (general or SEQ.NUM).javascript:emoticon(':lol:')
Laughing

Please refer to the Join Stage of the DataStage Job Developer's Guide. It explains the steps of creating outer join.

Hello All

Has anybody used anybody used shell script or Pearl script to extract job and sequence names?

If yes, could I use it?

email - bkamila@optusnet.com.au

Cheers, Bana

Hello DataStage Gurus!!!!!!!!!!! We have tasks to -- 1. Add 2 new job level parameters to 300 DataStage jobs 2. Remove Default Values of Parameters for 300 DataStage jobs We want to know -- what is easy and safe way to achieve above objectives without manually changing each job. Our colleagues have ...