DSXchange

@Mike ,Tried that option already ..Thank you

@Chulett, This is actually not a problem but some reason we change the source file column order just curious since many years we have an option to re-order the existing columns in the columns tab it self with out having to use transformer or other temporary stage for this purpose For Example :In my ...

:!: Developer9 - please use the Reply to topic option as there's absolutely no need to quote everything you are replying to. Saves me from having to come along and clean up as well. Thanks. @chulett,I made the change to earlier post to remove earlier post content. Thanks for the suggestion ..I hope...

Hi, I used transformer loop concept to convert a single row for data with repeating values in a single column (Dep_DSC_INDICATOR) to multiple output rows. Transformer loop job SEQ (INPUT) ---XFM --SEQ (OUTPUT) Logic in Transformer --Stage Variable 'svDepDelim' Dcount(Seq_AreaList_Out.Dep_DSC_INDICAT...

Hi , I am looking for a way to re-order metadata (Drag and Drop something like we do it in a transformer stage or other stage that supports mapping ). Ex:Sequential file stage -output --columns tab I tried re-order desired column order --map back to the sequential fie stage ) Seq --xfm stage Thanks.

Hi FranklinE, Edited earlier post The original requirement to group the employees per Area based on maximum limit set for each group .(<= 4800 per group ) Source File Employee Number,Area,Department For instance Area 1 -2500 employees , Area 2 -2300 employees Area 3 -2000 employees Area 4 -2000 empl...

Hi , I have the following requirement I am developing Seq/parallel jobs. Dep_Group logic --Per group limit -5000 employees (records with Dep_Indicator BCF,DS) Non_Dep_Group --No grouping required -Assign default '0' (records with Non_Dep_Indicator DW) Input File Area|Employee_count|Deparment|Dep_DSC...

Thank you all for the input ..There was a requirement change holding off my testing ..still want to test this scenario I am creating a new post for the new requirement

@Chulett, Sorry I was caught up with the testing my jobs. Input (source) Div|field 05|X 25|X 30|X In my target TERADATA DB (field) it is defined as an integer but for my testing I choose value as X instead of integer value :) I guess that is the reason it is throwing that warning. Thanks for the fol...

Hi , I am using Teradata DB for my source and target ..some of columns defined as integer JOB 1 TD ---Target ds Seq file columns defined as varchar otherwise If I am giving as integer getting the following error JOB 2 Seq_Read,0: Field "field" has import error and no default value; data: {...

@Chulett,

At my place we might move to 11.5 but not immediately until then I need to build the logic in place to support this task.

Thanks

Hi , I have a requirement to generate output files based on the division Grouping populated in a table (group numbers subject to change depends on change in the data) Group| Division 1 5 2 5 3 5 N 5 1 25 2 25 3 25 4 25 5 25 6 25 7 25 Output : Division 5-File 1,File 2 ,File3 ..FileN Division 25-File1...

Hi Everyone, We got some advise from IBM to include environment variable of APT_STARTUP_STATUS=1 for better idea on why the job is taking so long to startup.

Does this approach helps in the root cause of the issue. please provide me your input

Thanks,
DS user

@Mike/Chulett,

We are looking out for a option of scheduled DBA task. I came to know that application ID doesn't have access privileges

Thank you .

Hi, I have a production (multi instance) extract job which is running couple of hours daily for only one deployment data other deployments are running fine ,While testing in QA for the root cause took only about 10-15 minutes when DBA collects stats before job execution. Oracle connector ---->extrac...