DSXchange

I have checked ds log for that run. only i am able to see insert query,not able to find the insert record count.

Thanks Chulett. I have executed 2 times,i want to find previous execution record count.

Hi,

i am using multi instance job.is it possible to check how many records are inserted in table from director?
also please let me know what are the other options to check the records inserted in table without using query.

Thanks in advance

Hi All,

can anybody explain the datastage 8.5 architecture or please share the link.

Thanks
Mallikharjuna

Thanks ArndW.I have used this function,working fine.I think the return code 1-7 for Sunday through Saturday, then Saturday=7.Please correct me if i am wrong.

Hi,

I have 2 jobs in sequence ,first job will execute daily and second job should execite if it is Saturday, how to implement in sequence? any built in function will help?

Thanks
Malli

I am not able to read fixed width file from sequential file stage for Example My Source file is 14.22 decimal(2,2) 7.4(decimal1,1) abc(char 3) Error Message:record_length=fixed" (no length given) and record field format is variable-length i have tried to read source as all char type and convert...

Hi All,

My Source table is having 50 lacks records.i have applied few transformation rules in trasformer stage based on my requirements.my job is taking 40 minutes time to finish.

please let me know how to improve the performace in transformer stage.

Thanks in advance

Sreenivasulu wrote:You can set the transaction size. Setting it to 0 means ALL / None approach

any other way?

Hi All, My job design Dataset---> Transformer stage----> ODBC stage or OCI (Oracle). Source has 3000 records, my job is aborted after loading in 1500 records. How to load the remaining records in my target Oracle table? Another question: I want to load records if the job successfully completes. Is t...

Hi All, i have tried to insert records in DB2 TABLE,but the below warning message is coming Ex:"INDEX U2RPROCO RESTRICTS COLUMNS WITH SAME VALUES. 0000083605" No record exists with same value 0000083605 in DB2 table. lot of warnings are same type,just given one for example. please suggest ...

Hi, I have to join(left outer join) the data based on two columns. i have used join stage.my source and reference datasets having huge volumes of data. i have used sort stage before doing the join in both source and reference data based on join keys. my question is which is the best option, with out...

Hi All, My source is teradata table,i have to remove the duplicates based on one column. I know few ways to remove the duplicates 1)User defined source Query 2)Remove duplicate stage 3)By using sort and transformer stage. in above three options which one is the best one if the volumes of the data ar...

Thanks George

Hi All,

I have some working experience in Quality stage but only few stages i have used.

My question is

I have not found Australia phone number Standardization rule sets in Quality Stage.
please post if anybody having the Australia Phone number Rule Sets.

Thanks in Advance
Mallikharjuna Reddy