DSXchange

Hi, In IA we had run the column level analysis for a table T1, after that deleted everything(Host, Datastore, Database and Table) in IA. Now imported the same table T1 in IA under different host, datastore and Database. When i see that table Index and Analysis tab in workbench it is still showing pr...

Thanks Ernie for response. Even if i un-define the aliases then also i am able to see linkages between stage to stage because file names are same in both the jobs so it is getting bound before giving aliases. Yes it is true lineage, but my business people want to see lineage on original jobs only(Th...

Thanks eostic for prompt reply. i am assuming OMD is Operation Meatadata, and my job is not connected due to OMD, it got connected due to same dataset name present in original job and one time run job. and i dont have write permission to those jobs, so i can not do code changes. So i have to do unbi...

Hi All, We have some one time run jobs in datastage project and ran automated services for that project. we found that one time run jobs also binded with original jobs. So we wanted to unbind those one time run jobs and tried to unbind from Stage Item binding option but we did not see any stage bind...

ksh: ProcessEnvVariables.sh: not found. That indicates that the current directory (i.e. ".") is not in your PATH environment variable. You can add the dot to your PATH and/or run it like this: Make sure the script is actually in your current working directory ( ls command) and prefix the ...

Hi Team, we ran automation and able to bind databases in development environment, able to run the ProcessEnvVariables.sh script properly. Ran the automation in testing environment but database is not getting binded and i am not able to run ProcessEnvVariables.sh script also for assigning project lev...

Hi, In Production environment many more adhoc jobs are there, all those are production fix jobs. we dont want to delete those jobs. when i run automation binding those jobs are also binding with ongoing jobs and giving wrong report. Do we have any way to not include those adhoc jobs in automation bi...

Thanks to Ernie Ostic and vmcburney
Will go through the link..

Hi Team, I am new to Metadata Workbench....i heard some points regarding that..could you please confirm those are correct or not. 1)In automation binding the output stage name of Predecessor job and Input put stage name of Successor job should be same? 2) In automation binding can't we bind the Stag...

Hi All, i have a dataset called ABC.ds, doing compress and loading to BCD.ds and second job is for read compressed dataset and load into CDE.ds job design is like ABC.ds --->Compress stage(compress)--->BCD.ds Now i want to expand BCD.ds to CDE.ds, my job design is like BCD.ds --->Expand Stage(Uncomp...

Thanks Ray and kmsekhar, issue solved.

Hi All, My source is delimiter text file, i am reading as char datatype for all columns. Timestamp filed coming as (2008-05-15-14.59.36.000000). i am using modify stage to convert all datatypes and laod into DB2 table. but for timestamp columns some times it as coming as null and i have to load as n...

i have Date fields in 100 files, If it is possible then i can do in one job, otherwise i have to create 100 different jobs to lado data into DB2 tables.

Appreciate your help.

HI All, My requirement is like, fixed length sequential file is source, i am reading as char datatype for all columns. TRAN_DATE is the column in that, i have to load in target table as date datatype. For some of the recordsit is coming as spaces. i am using modify stage to convert string to date an...

Thanks Jwiles, Its working.