Search found 67 matches
- Wed Mar 19, 2008 7:39 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Filling gap records
- Replies: 5
- Views: 1371
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 ...
- Wed Mar 19, 2008 7:09 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Filling gap records
- Replies: 5
- Views: 1371
Filling gap records
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...
- Sat Feb 09, 2008 11:56 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: APT_CombinedOperatorController(1),0: Fatal Error: Null value
- Replies: 1
- Views: 2948
APT_CombinedOperatorController(1),0: Fatal Error: Null value
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
i am reciving this fatal error
APT_CombinedOperatorController(1),0: Fatal Error: Null value on the accessor interfacing to field "Column name".
Thanks
- Tue Feb 05, 2008 10:36 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: converting the null
- Replies: 5
- Views: 2838
converting the null
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...
- Mon Feb 04, 2008 7:10 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: to find the min value
- Replies: 2
- Views: 681
to find the min value
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...
- Mon Jan 28, 2008 8:14 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: APT_CombinedOperatorController(0),1: Field Colmun name
- Replies: 1
- Views: 1068
APT_CombinedOperatorController(0),1: Field Colmun name
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
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
- Mon Jan 28, 2008 5:51 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: APT_CombinedOperatorController(0),3: Field 'COLUMN NAME' fro
- Replies: 1
- Views: 1064
APT_CombinedOperatorController(0),3: Field 'COLUMN NAME' fro
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
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
- Fri Jan 25, 2008 2:08 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Extracting two records From ABAP Extract pack
- Replies: 1
- Views: 678
Extracting two records From ABAP Extract pack
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...
- Wed Jan 09, 2008 10:35 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Implicit conversion; from source type "int64" to r
- Replies: 1
- Views: 1398
Implicit conversion; from source type "int64" to r
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...
- Tue Dec 18, 2007 8:43 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to removw the duplicate words in thecolumn
- Replies: 2
- Views: 900
How to removw the duplicate words in thecolumn
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 need to get out put "ram sita ravan lakshman"
please help me in this
- Thu Dec 06, 2007 3:46 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: when I import the metadata for this column datastage is conv
- Replies: 2
- Views: 916
how to retrive the data from CLOB Column through datastage
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.
- Thu Dec 06, 2007 1:52 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: when I import the metadata for this column datastage is conv
- Replies: 2
- Views: 916
when I import the metadata for this column datastage is conv
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...
- Fri Nov 30, 2007 6:36 am
- Forum: General
- Topic: how to find the enddate
- Replies: 1
- Views: 998
how to find the enddate
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...
- Thu Nov 29, 2007 12:29 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Needs to remove duplicate words with in the column
- Replies: 1
- Views: 892
Needs to remove duplicate words with in the column
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 ...
- Wed Nov 28, 2007 12:05 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: how to get the no of days between two dates
- Replies: 4
- Views: 2841