DSXchange

My requirement is to handle exception and rejection dynamically. Perhaps you could give a little explanation as to what this means to you. What I meant was I have some exception/rejection rules to be applied on a Column A. 1. Value is null - reject(reject means rejected values are captured in a rej...

My requirement is to handle exception and rejection dynamically. Perhaps you could give a little explanation as to what this means to you. What I meant was I have some exception/rejection rules to be applied on a Column A. 1. Value is null - reject(reject means rejected values are captured in a rej...

Hi All My requirement is to handle exception and rejection dynamically. After doing bit of reading I have learnt that I can do this using ETL/Business rules table. This table is a repository of all the rules which can be called by any ETL process. I started trying it. Has anyone implemented this bef...

Hi All,
Is there anyway to get the elapsed time of each and every instance of a sequencer. I know can get it from the director but can I find it in any file or table where this information is stored.

Pls advice.

Arnd,
Sounds like its a good idea. Thanks for that. Let me check with the DBA.

cheers,
suneeth--

Hi All, My Requirement is I need to split the data into Active which holds the current day's data and On-line history data which should contain the history. I need to perform this on daily, weekly and Monthly basis. I also have reports accessing this data any point of time. Can anyone help me in th...

Hi All, My Requirement is I need to split the data into Active which holds the current day's data and On-line history data which should contain the history. I need to perform this on daily, weekly and Monthly basis. I also have reports accessing this data any point of time. Can anyone help me in the...

thanks sandy,
Format is same. The data is inserted into the same table with the date increment.

Hi All, I have this new error for all my jobs in my production environmen which never occured before Job 1 main_program: Fatal Error: Not a v1.1 type: decimal[19,2]. Job 2 main_program: Fatal Error: Not a v1.1 type: decimal[10,0]. Job3 main_program: Fatal Error: Not a v1.1 type: decimal[15,2]. I hav...

Hi Kenneth Bland, Many thanks for the quicky response. Mainly I am looking at different approaches in achieving that. 1. Load into tables & join them. 2. Merge stage can be used. Or do we have any other approaches. cheers, suneeth-- Lots of ways: 1. Load each dataset into a separate table and us...

How would one merge multiple files into single data set with columns from each file becoming a new column in the merged data set?