Search found 65 matches
- Tue May 08, 2012 2:23 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Type Mismatch Error for Time Datatype.
- Replies: 2
- Views: 2195
Type Mismatch Error for Time Datatype.
Hi, Source: Oracle(two fields as Char(6)) Target: Teradata(Time(15,6) length) Transformed the data from Char to Time and the data looks fine. However, when I am trying to load the data into teradata table, it aborts with the following error message: "Error when checking operator: Type mismatch ...
- Wed Apr 11, 2012 1:11 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: complex logic
- Replies: 7
- Views: 3562
Priyadarshi Kunal : Thanks for the reply. As i stated in my previous posts, I am new to rank and have no idea on how to use it in this scenario. Please shed some light on it. Also, you mentioned I can use Left Outer joins to do the same. I am not sure How can you handle the OR/Between clauses using ...
- Wed Apr 11, 2012 8:16 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: complex logic
- Replies: 7
- Views: 3562
Thanks for the reply. Ray: Thought Rank might help in using the Sql. Kryt0n/qt_ky : I though of the same, however my join conditions have OR/And/between conditions and I am not sure how to use this using Look-up/Join/Merge. Also, the reference link has about 8 million data and I am not sure using a ...
- Tue Apr 10, 2012 3:08 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: complex logic
- Replies: 7
- Views: 3562
complex logic
Hi, I have a scenario which requires to be done through ranking, however, I have never done ranking before and would need advise on how to handle it. Scenario: I am working to extract some member_Sk's which needs 7 different look-up's, as to not drop any record. Source: Oracle Target: Teradata Look-...
- Fri Feb 17, 2012 3:47 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Sequential file
- Replies: 1
- Views: 1555
Sequential file
Hi, I have a sequential file in .csv format. Now for any Cust_NM's with "," it assigns quotes. Input File: Cust_Cd, Cust_NM 100, abc 101, "qbc, 123, 145" 102, "tmgi123's, and west" 103, destri However, when I try to view the data, I have an offset error at Cust_NM when ...
- Tue Feb 14, 2012 10:09 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Replacing Non-Numeric values
- Replies: 3
- Views: 3526
Ray, yes we are checking for values equals to ''. Also, it works fine. Sometime Datastage acts wierd. I thought CHAR(0) handles the null values? Itseems like it doesn't, so I had to handle the Null values first and then the actual logic. Used the following: svZip4Cd = Trim(NullToValue(ZIP4,' ')) svZ...
- Mon Feb 13, 2012 4:30 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Replacing Non-Numeric values
- Replies: 3
- Views: 3526
Replacing Non-Numeric values
Hi, I wanted to replace any Non-Numeric occurences in the data for Zip codes. I have succesfully done so for Zip_Code5. However, when I use the same logic to resolve fr Zip_Code4 it wont print any values. svChars = CHAR(0):CHAR(1):CHAR(2):CHAR(3):CHAR(4):CHAR(5):CHAR(6):CHAR(7):CHAR(8):CHAR(9):CHAR(...
- Thu Jan 26, 2012 10:24 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Date Logic
- Replies: 7
- Views: 3517
- Thu Jan 26, 2012 10:21 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Date Logic
- Replies: 7
- Views: 3517
Well I tried to get the given output using the Sql. Dint really know, how to accomplish using the Sql. Cust----Rep---RepMinDt---RepMaxDT---BrkrMindt---BrkrMaxDt---BrkrNm 2257---123----200501-----200509-------200202------200511-------a 2257---126----200510-----200701-------200202------200511-------a ...
- Thu Jan 26, 2012 8:32 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Date Logic
- Replies: 7
- Views: 3517
Sorry about that. If you have noticed in my given input data, we have Customer id , rep code and broker. Also, we have two sets of Min and Max dates. Now the Broker Min, Max dates are at the higher level. Now we need to get the Rw_eff_dt and Rw_exp_dt, for the customer, rep associated with Broker. F...
- Thu Jan 26, 2012 5:01 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Date Logic
- Replies: 7
- Views: 3517
Date Logic
Hi, I am not sure, How silly this question is, I am still gonaa ask away. :) I wrote a query, in order to get my result, however, I stuck at extracting the Min and Max Dts. After the query this is how the data looks like: CustId Rep MinRepDt MaxRepDT MinBrkDt MaxBkrDT Brk_NM 130 2257 200501 200509 2...
- Wed Dec 14, 2011 3:34 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Help with Logic
- Replies: 7
- Views: 5409
Hi All, I have previously marked this topic to be resolved. Thought I got my desired output. However, my logic does not cover one of the important scenario. Used the aggregator stage to get the min and max of the time period by grouping on Cust_ID and Rep_Cd . my input is in this way: Cust_id Rep_Cd...
- Wed Nov 30, 2011 2:05 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Help with Logic
- Replies: 7
- Views: 5409
- Wed Nov 30, 2011 8:04 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Help with Logic
- Replies: 7
- Views: 5409
- Tue Nov 29, 2011 10:18 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Help with Logic
- Replies: 7
- Views: 5409
Thanks for your quick response. I am deriving the currepkey using another Transformer. Used two Stage variables: PrvRepkey = Currepkey Currepkey = Rep_Code Used the following Stage Variable in the next Transformer using the Below Stage variables: PrvEffDt = CurEffDt PrvExDt = CurExpDt CurExpDt = If ...