DSXchange

Hi, I have a EBCDIC file and in that file i have different record indicators. The last fields in file contains sub-columns ie., the meta data of the last field varies based on the record indicators. Designed a job Sequential file (with last column defined as VarBinary) --> Transformer ---> Load data...

I am able to see the data is being round off to the nearest value.
So need help to prevent this.

Input : 123.448

Output as per data stage job : 123.45

Output expected is : 123.44

Hi, There is a oracle table which has below column "DEP_ID" Decimal(22,5) But while reading data from the table using datastage i have declared metadata in the "ORACLE CONNECTOR" as Decimal(22,2) My concern is will it just truncate the rest of the decimal part or will it round of...

Hi ,

Requirement :

Based on the first column data(Record Type) need to pass the values to the concerned columns in the table and rest need to be null.

Many columns are there so not able to define using Transformer stage.

Can anyone help how to build a Buildop.


Thanks,
Anu

In CFF stage how many Record Layout's can be defined.Can anyone help me out.

Sorry arun. I was out of station...

Its a fixed width file

If it is less number of First Concern is : We have '0' to '999' record types ,so defining this many definitions in the record layout in one job.Is it a right way to design? Second Concern is : While populating the data to target table i should concatenate the values extracted from DEP_DATA and load ...

Ya true if the metadata is same then i can go ahead with Complex flat file but here the metadata is not same for all the record indicator. Copy Book: REC_IND CUST_ID SAL CUST_NAME DEP_DATA --> for this field the number of columns Varies for different record indicators. for record indicator=2 or reco...

Hi, I have a EBCDIC file and in that file i have different record indicators. One column in the record varies based on the record indicator. This coulmn include set of the columns specific to that record type. For some record indicator you will have packed decimal filed for some it is not there. So ...

Ya i have tried to do using Column export stage but padding the space was not happenning

Hi all, I have 5 columns with varchar datatype in the oracle database . I need to read those 5 columns and need to generate 3 columns. The example how to generate 3 columns is mentioned below example : Input: C1,C2,C3,C4,C5 are there columns in the database. Output: C1 , C2 , C3C4C5 Third column is ...

Thanx....If it is just inserting i would have done in stage variable but here i need to insert and update so how to do....

Thanks,
Anu

Hi,

If new employee need to insert the following columns:
No_Of_tries=1
Pro_Id = ID
OriPro_Id = Null

If existing employee need to Update the following columns :
No_Of_tries= No_Of_tries+1
Pro_Id = ID
OriPro_Id = Prev_ID

How to update the table by incrementing the value , can you please suggest...