DSXchange

I have two DATE to be compared in transformer's constraints,

As I need to make sure whether their difference is bigger than 2 year or not,

How to write the code, seems that there is no specific function for such a purpose,

Hi, i am getting warning in sort stage. main_program: Sort key "START_DATE" no longer exists in dataset schema. It will be dropped from the inserted sortmerge collector. main_program: Sort key "REASON_CODE" no longer exists in dataset schema. It will be dropped from the inserted ...

All I am getting follow warning, when summing up the column using aggregator stage. source data type for that colunmn is integer and target datatype is dedimal 9,2 Aggregator_104: When checking operator: When binding input interface field "DRAW" to field "DRAW": Implicit conversi...

Hi all

In transformer I want to subtract -1 microsecond from the incoming timestamp '2011-02-24 07:53:08.266692' after comparison and I should get output as '2011-02-24 07:53:08.266691' Can you let me know how to achieve this is Datastage?

Hi All, If we have MPP machines (four server), 1. Is it possible if we want to setup MPP machines if the machines aren't exactly similar (different CPUs between each machine) 2. What is the best configuration to optimize the performance (Is there the difference between using Unconnected Conductor wi...

Hi I have a requirement where I have to fetch few files from a folder of similar pattern and having same metadata and then need to apply some transformations on it and then I have to produce same no of files fetched from the source folder and place them in target folder. Ex: dir1 has 210 files and i...

Hi Is there a way to identify how much scratch space is being used from the Logs? I am receiving this error Fatal Error: Tsort merger aborting: Scratch space full and would like to know how much space I need to add. This particular job is reading a 600MB sequential file, performs 3 sorts, 1 Lookup a...

Hi All, I need to give a document on Performance tips and Coding standards before the project development starts in Datastage. Since I am new to Datastage can you help me in this. By performance tips I mean things like: 1:Whether its better to use an SQL Join Statement or a Lookup stage or a Join st...

Hi all, I need to load job information like source filename and pathname,Job name, Job status, job start and end time, Number of records processed and number of success records and failure records into another table. Is there a way we can can retrieve all the information other than scripting? Or els...

One of my jobs aborted for the following error: main_program: Fatal Error: There are irreconcilable constraints on the number of partitions of an operator: parallel FnlPartys. The number of partitions is already constrained to 2, but an eSame partitioned input virtual dataset produced by parallel Al...

In Generic stage, there is a Options properties which is asking for the name of Orchestrate Operator. Since I am new to this I couldn't make it out what is this really mean? Seeking reply Please.

i was hoping someone would know all the job status and link type return values...for example...job status of 1=OK, 2=OK with Warnings, and 3=Abort...i would like to specify additional job statuses in a process control table and want these additional statuses not to overlap onto existing status value...

how to transfer environment variables from one project to another project?

i am new to datastage
i changed .xlsx file as a fixed width file.
when i use fixed width file as a source.
after import the metadata. by view data option it's not retrieving proper data.
(error: import short data)

Dear All, - Recently, there is a requirement that performing data audit throught datastage job. Its functionality includes store error data in a separate file along with error message, row number and source name when detect a violation in terms of data type, length of character string, etc. - So, if...