DSXchange

Observe carefully...U have compared just the First column with the rest...where u checking the in-between cols with each other! S actually I noticed it but how can i achieve it. If I go for multiple not equal conditions the querry will become huge. So is there any other Idea of achieving this. Is t...

Hi, I have an issue with the data comparison Totally I have 30 columns. Data in all the fields should be unique. I tried to achieve this using transformer ex: Trim(DSLink6.ACC_NBR) <> (Trim(DSLink6.BAL_AMT) Or Trim(DSLink6.BAL_EFF_DATE) Or Trim(DSLink6.BAL_END_DT) Or Trim(DSLink6.WTHD_AMT)) I cannot...

chulett wrote:And what did you find in the LOG file? ...

Thanks for your quick response.

I finally resolved the issue.

I found out the error by going throug the oracle log report. The problem is with the souce data provided.

Data is declared as null in source for not null columns.

Hi, I am trying to load data from a flat file to oracle data base. I am Using Oracle Stage to load data Properties set: WriteMeathod = Load WriteMode = Append But it is throwing warning Warning Message: Oracle_Enterprise_3,0: The system(sqlldr system/oracle@Orcl CONTROL=ora.1286384.380289.0.ctl LOG=...

Hai Everyone,

Thanks for your response.
It is problem with the format of data in the dsx.


We are able to load metadata into datastage.

Hi, We are trying to automate the metadata creation and so we have written a excel macro to fulfill the requirement. We are able to create .dsx file but when we are trying to import the .dsx file using datastage manager it is throwing out an error Error message in Datastage manager: Unknown property...

Hi, Question : To convert format of date. 1) 05aug08 to yymmdd and 2) 05aug08 to yyyymmdd Solution: Use this function in transformer It will work. This is for fist one: DateToString(StringToDate(DSLink8.a,"%dd%mmm%yy"),"%yy%mm%dd") Second one: DateToString(StringToDate(DSLink8.a,...

Hi, Question 1 : Convertion of varchar EX: 9/28/2007 to 2007-09-28 00:00:00.000 Solution: As your reading this as varchar in transformer you can do the convertion. I am specifying the logic StringToTimestamp(DSLink8.a :"000000","%mm/%dd/%yyyy%hh%nn%ss") DSLink8.a is the input col...

Hi When your target is a sequential file then this is the solution... Date conversion : I/P: Ex:20061107 TransRule: StringToDate(<Input Col>,"%yyyy%mm%dd") Change the properties of the sequential file.Set Date formatt string to your require formatt Ex:%mm/%dd/%yyyy O/P:11/07/2006 Note : wh...