DSXchange

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 ...

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 ...

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 ...

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-...

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 ...

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...

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(...

Thanks. Dint see your post. Will try that out after grouping them. Will let you know.

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 ...

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...

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...

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...

Got it. I have used an Aggregator to get the Min & max of the time period.

Can anyone suggest, what i am missing in my logic.

Any advise would be appreciated.

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 ...