DSXchange

Hi all, How to load data into Dimension table. The following is my requirement We have Dimension table as Gl_Acct_Dimnsn ,it contains columns like Gl_Acct_Id,Gl_Acct_Nbr,Gl_Acct_Grp etc. We have to load the Gl_Acct_Nbr from source table (which contains column Gl_Acct_Nbr) to Gl_Acct_Dimnsn table. I ...

Hi all; I am sorry ,i posted it uncorrectly. what i intention is to capture the rejected records which are of incorrect format or datatypes. for example we are using the sequential file in our job to import the data . and if the data is of in correct format then we are capturing the records in to an...

I have 174 records in input file but i am getting only 173 records as output and 1 record is rejected.I want to capture the reject record or display the reject record. reject record is displayed as one column as {1a} but i want the whole record to be displayed.I am capturing the reject record in seq...