DSXchange

We have Date fields stored within a SQL Server 2000 Database in the char format YYYYMMDD. I am trying to confirm that the data is in fact a valid date from within a Data Filter. When I set the TypeofCheck to TYPE and set the Reference Data field to DATE the sql syntax generated becomes ISDATE(fieldn...

Hi All, This is my first post so please be gentle. Synopsis: Job Design ODBC -> Transformer -> Seq (fixed length) -> QS Plugin (STAN) -> Seq (fixed length) The issue I have relates to poor performance once job reaches the QualityStage plugin stage in DataStage. The stage is simpy a standardise stage...