DSXchange

Hi All, i am facing issue with Russian characters source file contains Russian characters when i am loading in teradata database it is populating with different characters. target field : COL1 VARCHAR(240) CHARACTER SET UNICODE NOT CASESPECIFIC, i tried below option : 1. in schema file i placed a. c...

Hi Andy, Sorry, it is a typo mistake. orchadmin dump -field ABC TGT_FILE.ds |sort|uniq Using compress stage we compressed the dataset. I am able to describe the schema using orchadmin describe -s TGT_FILE.ds but unable to view the data using orchadmin dump -field ABC TGT_FILE.ds Thanks, Karteek M

HI all,

any suggestion on below thread.

Hi Everyone, I am unable to read compressed data using orachadmin command. orchadmin dump -feild ABC TGT_FILE.ds |sort|uniq error: ##E IIS-DSEE-TOPK-00007 06:33:07(004) <APT_PeekOperator> Error when checking operator: Input dataset does not have field: "ABC" i am able to see describe the f...

Thanks craig.

Hi Everyone, how to get list of job names for only particular folder , using below i can get list of job names for entiire project but i need jobname for a particular folder dsjob -domain -server servername -user -password -ljobs projectname for example : Jobs/LB_TESt[folder] contains 10 parallel jo...

Thanks craig , as per my understanding Surrogate Key Generator stage will Not generate Negative values , Hence i have to change oracle sequencer it will start with 1 increment by 1, before inserting i will multiply with -1 and also i cannot alter this sequencer. But if any application uses this sequ...

Hi ,

Thanks for replay, i used datatype : BIGINT,Unsigned still same error.

does Surrogate Key Generator stage will generate Negative values.

i tried with other datatypes same error.

Thanks,
Karteek M

Hi Everyone, How to generate Negative values in Datastage using oracle DB sequence. My sequencer: CREATE SEQUENCE FAKE_ID_SEQ_1 START WITH -1 INCREMENT BY -1 Error: APT_CombinedOperatorController,2: Sequence FAKE_ID_SEQ_1 returned invalid next value: -1. i can write insert statement and i can give t...

Any suggestions on this issue.

if start_date and end_date datatypes are DATE then in transformer convert both date fileds to days then you can comapre both of them take 3 stage variables 1.SvStartDate: JulianDayFromDate(lk.start_date) 2.SvEndDate: JulianDayFromDate(lk.end_date) 3. CALC: if SvStartDate > SvEndDate then 'X' Else 'Y'

Hi Everyone, i am migrating around 30 million records into oracle table,my datastage configuration is 4 node. i have two tables 1. Physical_item(parent table): Physical_item_id [primary_key] data: physical_item_id 1 2 3 4 5 2. PM_IMAGE_SECT(child table) which contains 30 million records. Image_sect_...

hi , my datastage load job : dataset[src] ---Xfm stage-----lk_ld--->oracle connector[destination] | lk_sqlfl_write | v sequential file stage in transformere stage for the link lk_sqlfl_write i will harcode : 'INSERT INTO EMPLOYEE ( E_ID,E_NAME) VALUES( ' : E_ID :',' : E_NAME :');' by using this i wi...

hi dsetlteam, Thanks for your replay. i achived this by using below steps: 1) fetch emp table data into one sequential file. sequential file name : emp_20.txt emp_id e_name --------- --------- 123 A 245 B 786 C 2) use this sequential file to get record count. sq_file_stage(set row number column [row...

Hi chulett, I apologies on this, actually i tried with more logic. Unable to present my job design hence i didn't post what i am doing for this in DataStage: Reference table | | V step 1: src table -- lkp[key:ORIG_REF]====Multiple Row out put=====> transformer stage [TFM_MATCHED] | Reject | V transf...