DSXchange

Hello Ravi, The input we have is : GroupNO, GDate 200, 2009-03-02 100, 2010-01-01 100, 2009-02-02 200, 2008-03-02 The output we need is GroupNO, GDate 100,2009-02-02 200,2008-03-02 One way of doing this is by using a remove duplicate stage. The input to the remove duplicate stage should be sorted ba...

Hi All I am reading a Cobol file using a CFF stage.It is a fixed width binary file and the charadcter set is set as 'EBCIDIC'.There is an alphanumeric field in the source which "PIC(20).I am trying to read the particular field as "character" and have set the usage clause to "DISP...

Thanks for replying Hamzaq.

What will happen if the input key column values contain nulls.Will hash partitioning ensure that all the nulls will go to the same partition.

Hi All, I want to understand Hash Partitioning in Datastage. I understand that if we define Hash Partitioning in a stage then the records having the same value for the mentioned Key Column will go to the same node. However what will happen if the key column is nullable and some of the records contai...

Input field is a decimal (eg. 00012.)..
This is to be converted into integer, with the preceeding zeroes retained.

Does anyone have any solution for this...?


Thanks in advance.

Hi, We are using the following function to populate date with corresponding timestamp in one of the fields "Oconv(Date(),"DYMD"):Oconv(@TIME,"MTS")" The function gives correct results but for a job whose execution started at 11:55 PM on 3rd March and ended at 12:05 AM 4...

Hi...
What are RT_BP and RT_STATUS files which are present in the project directory.
Can we delete these these files if we have to relese some space from the directory without affecting the jobs?

Thanks in advance.

Hi, My requirement is to check the value for a particular field.If the value is null then send the entire record to error table else pass it to output. I am using the following condition in the constraint field. IsNull(input column) the job executes well but the error table is not populated with the...

how to fetch the last row of a particular column? what should be used? transformer or aggregator??? Well.....One way can be to use a transformer stage and generate a new column which will be made to store numbers in increasing order.i.e the column values will act as a row number.Then we can use an ...

Hello, I am fetching my data from Oracle database,using ODBC connections.After processing ,I am trying to load it back again to the Oracle database using a different ODBC connection in a different table ,of the same user. While loading I get the following error: APT_CombinedOperatorController,0: [Or...

Hello, I am fetching my data from Oracle database,using ODBC connections.After processing ,I am trying to load it back again to the Oracle database using a different ODBC connection in a different table ,of the same user. While loading I get the following error: APT_CombinedOperatorController,0: [Or...

Hello, I am doing a job,involving data to be loaded from a sequential file. Although the job is running I am getting the following warning from the sequential file stage: 1.Sequential_File_39,0: Import consumed only 37bytes of the record's 38 bytes (no further warnings will be generated from this pa...

Thanks a lot Mr. Wurlod.
Placing a copy stage in between the modify stage solves the problem.

Regards

Hello, I have been trying to convert a date present in a flat file in yyyy-mm-dd format to mm-dd-yyyy format and store it in a database. I have used a modify stage to convert the given date to string in mm-dd-yyyy format using String_Date_Function. Now, before loading it into database as the string ...