DSXchange

i am giving idea for that one not same team

Hi, if jobs are in job sequence in job activity stage we should set triggers for that. In triggers we should set expression type as custom and write expression call activityvarible jobstatus=runok(system varible) or jobstatus=runwarn(systemvarible). then the job wont abort and after finishing if u h...

Hi ,
I have imported that one from osh schema defination.is any differnce when importing metadata from plug-in metadefination and osh schema
Thanks
v..

Hi,
I have one table product in oracle database.i have to take this one as a source.how we wil get Orchestrate schema defination. After executing job we wil get orchestrate schema defination from dsx file.before how we will get OSH schema


Thanks
....

Hi,
my source is oracle database in that for some fields data type is varchar2.
when i am importing meta data in oracle oci stage in datastage what i have to mention data type in data stage(for varchar2 equivalent datatype is varchar or someother)

Thanks

Hi, I have delcared some jobparameters for jobs. at the time running i have to give values for that parameters stgdbuserid stgdbpassword for example above two are parameters.but i need to give values for that from one text file.for that i wil get one text file(in that the values are availble for job...

Hi, i have two tables transcation,product TXN txn_id pd_id rev in product pd_id pd_nm in output i want this target is hashfile pd_id txn_id pd_nm rev procedure1: i will write query it self in database stage procedure2; using transformer and source and refrence as tables(lookup in server ) In both wh...

Hi, I Have two tables .Daily i will get 0.1 million records.i have to join two tables with key column and i have to retrieve one column from other table. i have overwrite query in oracle oci stage(i used join query itself) is inthis way good performance wise or using lookup performance good which pr...

Hi, from existing dsx i am creating multiple dsx files with different metadata for example source eid,dept 1,cse 2,ece 3,cse the source is txt file and loading into dataset i did one job for this one.i next i am getting another new file but i wont do new job with existing dsx i wil change metadata ....

Hi, I have removed orchestrate code from dsx(one job of dsx) and again i imported dsx(which has with out orchestrate code) after that also i got succeed in importing and i got job in designer.what is the purpose of oshcode. ################################################################# #### STAGE...

Hi, transformer stage varible part declare first two stage varibles in trasnformer a=@inrownumber(from system varible you wil get) b=if mod(a,2)=0 then 'even' else 'odd'( you wil get mod operator in functions--->mathematical ) constraint in the first constraint give b='even' in the second constraint...

Hi,
Thanks a lot.

thanks
vin..

hi, I have tried with that one.but in my source under one column data will generated dynamically its not fixed ename mid aa,bb,cc 1001 cc,dd 1002 ee,ff,gg,hh,ii 1003 here we not constant under ename we may get more than 5values also with comma.how can we will divide columns with comma deleimeter. Th...

Hi, we cant do by using pivot stage for that scenario. i have tried with pivot stage also.in the pivot stage we can merge data from 2more columns to single column.but here singl column row data we are spliting into under same column multiple rows. if any other solution...please tel me Thanks vin..

Hi,
Please help me for this...
Thanks
vin...