DSXchange

Hi All, Can any one through some suggestions on the following Err DataStage Job 785 Phantom 27904 Program "JOB.891742608.DT.1368838389.TRANS1": Line 1173, Improper data type. I have checked each and every data type,every thing is perfect. The job was running fine y'day, after changing the ...

Thanks Ray and Vincent

Hi All,

What are the ways(steps) in tuning the SQL. could any one help me.

Thanx

Hi All, My Data is coming from source with state code CA, NJ, MI, NULL, IL, KY..... and lookup OCI is having all 54 state code when i am doing lookup in stage and the cond is If field.StateCD = "NULL" or " " then "XX" else field.StateCD. but the result records is coming...

CREATE TABLE TB_GP_AGG_99950B1_&MMID TABLESPACE &TBSP UNRECOVERABLE PCTFREE 0 PCTUSED 99 STORAGE (INITIAL 10M NEXT 4M PCTINCREASE 0) AS SELECT * from TB_GP_PREAGG_99950B1_&MMID; CREATE INDEX IX1_GP_AGG_99950B1_&MMID ON TB_GP_AGG_99950B1_&MMID (SK_CU_L9_ID, PER_CCYYMM, BAL_CD, SEG...

Hi Ray,

Thanks for kind Response. Actually, Production is running on 6x and we upgraded dev 7x and need to upgrade Production with 7x then migration of all jobs from Dev to Prod.

Is it possible or not. Please let me know clearly.

Thanks

Hi all,

Please let me know the Upgrade from Version 5.2 to 7x and migration of all jobs into Production. where Dev is 7x and Production is 6x. Send me the link for Upgrading.

Thanks

Hi All, I am new to PX environment. I have a job to build aggregrators. i want to know the partitions and collecting the data process. there are like 9 tables joins and groupby, sum ...,. Is any of you developed jobs for Aggregators in PX. Please give me some important information on building Agg's....

Thanks Ray, Actually my team already developed the DS Jobs for the loads. my job is to migrate those DS Jobs to Production( where prd is now loading sqlldr). What is the process to start. They designed the model and DS Jobs, only to migrate those to PRD. One more issue, the orther case is like this....

Hi all, I am new to 7x and my client is developing jobs in 7x earlier the system DW runs under Oracle Scripts and converting all loads into DS PX. still production loads using Ora Scripts. I wanna know how to migrate all PX jobs from Development to Production, where PRD is Ora Scripts. Give me a bri...

Hi,

Is any one build Aggrigators using DS in PX

If yes plse let me know.

Tnx

Hi all,

Can any one help me in Planning & advice on upgrade to DataStage V7and Planning & advice on migration of DS jobs into a production environment and Best Practices advice.

I'll be really appriciate for kind responce

Thanks

thanks Roy, we have flat files in Unix Dir, which are my source files. I have a Hash file in that i have a Key Property_Domain, which i have to take the source file name as Property_Domain. there are like 30+ source files with diffrent names. these files will come every month. my question is, how to...

Hi All, I have a problem, I have to pick a flat file which resides in Unix ...Extract_dir Directory. i have to use the file name as my Domain name which is a key in my hash file. there are like 30files in a month or more. ex.. filename -- www.adhdinfo.com_sem_20031029.txt and in my hash file propert...