DSXchange

Hi All , I am getting following warnings lkp_isin,0: Ignoring duplicate entry at table record 6; no further warnings will be issued for this table lkp_SS_Asset,0: Ignoring duplicate entry at table record 8; no further warnings will be issued for this table does that mean I am finding duplicate entri...

Are you doing any transformation on the field Ref_Mainframe_Time_Stamp. If so, are you handling NULL's explicitly? If not, you need to do so to avoid dropping records. Usually, within the transformer stage, Null handling should be done for all nullable fields. Thanks Kris for your response , Yes yo...

Hi All ,

what does the following warning mean?

APT_CombinedOperatorController(5),0: Field 'Ref_Mainframe_Time_Stamp' from input dataset '0' is NULL. Record dropped.

Thank you all , appreciate your inputs.

Hi All,

How do I get difference two timestamps ?
I want to know if two timestamps are within a minute , how do acheive this?

Lets us say time1 is 15:41

time2 is 20:40

without doing substrings..is there a way to use functions.




Advance Thanks to you all.

Hi All, What is the difference between drop and reject options in lookup stage for Condition Not Met and Lookup Failure ? can some clarify? From the manual I understand it as reject will reject the record and write it to the reject file and Drop would just drop the record and cannot collect the drop...

Hi All, I need to acheive following logic in my job with lookup stage, sources (source and ref source) are files Settle Dates are same and Share Quantity are same and Mainframe Time Stamp for both records are within a minute and The first 3 digits of the SS Asset ID for both the records are same. Th...

Hi All , I am trying the below derivation in transformer, but it is not working as expected. Ie; on DEV/TEST environment , it should be as "Z-EQUITY" but it is giving as "EQUITY" And "SrcFileDir" is a job parameter. SrcFileDir = /data/edapd/ascential/file/BrsReImpl1Dev/...

Did anyone experience the same issue like this with the oracle connector stage ..? How can this be fixed..?

Any inputs greatly appreciated.

Thank you all.

Thanks Arnd for your response. I turned off the data conversion check box in the reject link still didn't load the file. The value in column 10 and row 3 is 0001-01-01 and there are such date values in other date fields too for sure it is an invalid date and this was successfully loaded to OCI enter...

Hi All , Data was successfully loaded into oracle table , using an OCI Enterprise stage But now when I am using oracle connector stage , I am getting fatal errors , regarding date field with the same load data file to the same table. Tble_Acct_Master_Full,0: [IIS-CONN-ORA-003005] A data conversion e...

Hi All, I am getting below compilation.. can you please let me know the reason.. Thank you all. Output from transformer compilation follows: ##I IIS-DSEE-TFCN-00001 16:59:32(000) <main_program> IBM WebSphere DataStage Enterprise Edition 8.1.0.5000 Copyright (c) 2001, 2005-2008 IBM Corporation. All r...

Hi All, I am using oracle connector stage without any reject link right now.. and getting following errors for Bulk Load.. Tble: [IIS-CONN-ORA-004006] The connector generated the following TRUNCATE TABLE statement at runtime: TRUNCATE TABLE TBLE_NAME. [IIS-CONN-ORA-004009] The connector truncated th...

Thanks for your reply.
Yes I have followed every step from manual for ODO clauses.As it has an ODO clause in it , I used variable block file , not sure If I have to just choose varaible instead of Varaible block.

It is a cobol file.. just an FYI , it has only one occurs depending on clause..

THank you,

Thanks for your quick reply. On stage page and records tab , It was showing as Binary actually when imported and shows as small int the outputs page and column tab.. As you asked me to modify , I changed on the stage page to Numeric (as I didn't see any integer type available on the pull down) with ...