DSXchange

Could you please elaborate, what is the calculation for the time gap? This depends on the value of the Id, i have to compare the EXPR_D value of the current record with the EFF_D value of the previous record, if they are not equal, then there is a difference in time gap., for which i should insert ...

Hi all, I have the sample data given below., for table based on Key(Id,Eff_D) Id Eff_D Expr_D 1 2007-12-1 9999-12-31 2 2006-04-13 2006-07-14 2 2006-10-10 9999-12-31 The first task would be to find if time gap exists for records of same Id, and next would be to fill the time gap with a gap record. Th...

Hi all,

i am reciving this fatal error

APT_CombinedOperatorController(1),0: Fatal Error: Null value on the accessor interfacing to field "Column name".

Thanks

Hi, how to convert null values into some default value in modify stage right now i am using like this the data type of the column is DATE column name is BEG_DATE BEG_DATE = handle_null(BEG_DATE,'1800-01-01') i am giving like this it showing some error """" main_program: Error par...

Hi all, i have a reqeriment like this let say i have 2 columns no1 is the surrogate key column no1 no2 1 5 1 2 1 8 2 8 2 5 2 6 i want find the min value of the particular surrogate key i know to do in the remove duplicates stage and sort but i want to know how to find in the transformer it self plea...

Hi all ,

APT_CombinedOperatorController(0),1: Field "Column name" from input dataset '0' is NULL. Record dropped.

i recived this warining.all the columns are nullable columns

Thanks

Hi all,

APT_CombinedOperatorController(0),3: Field 'COLUMN NAME' from input dataset '0' is NULL. Record dropped.

I am reciving this warining .if any body have any idea please let me know..that was very helpful to me


Thanks

Hi , Extracting two records From ABAP Extract pack, we are Storing that data in to Hash File(For Reference Purpose), getting some problem with this process... ABAp Table Records are like this manner: cust id controllongArea Company Code 200 1000 1003 200 1000 1000 But in Hash file duplicates are eli...

HI, when i am loading data from emp table another table to another table with same structure using odbc as source and target stages, i am getting the below error pls suggest me the same APT_ODBC_Enterprise_21: When checking operator: When binding output interface field "CREDIT_LIMIT" to fi...

i have one string like "ram sita ravan ram lakshman"
i need to get out put "ram sita ravan lakshman"
please help me in this

i have column as datatype CLOB when i was selected the column through the datastage i am getting the problem , when i import the metadata its importing the longvarchar and when i ran the job its giving the error.

when I import the metadata for this column datastage is converting as LONGVARCHAR, when I run this job , I am getting following error. Traceback: [6] APT_FatalPath::msgAssertion(0xfca3b7c7, 0xffbec7a8, 0xfca3b7cf, 0x6b2, 0x0, 0xcd4a8), at 0xff0db308 > [7] APT_OraUtils::querySchema(0x0, 0xfca5dde8, 0...

No1 no2 no3 eff_date end_date 1 1 1 2007-11-20 9999-12-31 1 1 1 2007-11-17 2007-11-18 1 1 1 2007-11-12 2007-11-15 This is the my sample source data..what i need is whenever the combination of the (no1,no2,no3) of the first record and the combination of the second is same the end date of the previous...

i have column contains data EX : "baby stroller baby toys blue stroller " from this i need to remove the word contains more than one time in this example "baby stroller " word are repeated i need to keep only first instance i need to populate out put as like " baby stroller ...

Thanks KoolNitz