DSXchange

Hi

i wants to pass shell varible as datastage job parameter. please any body can help me.my DBA was aking me to pass shell variable as datastage job parameter insted of job level parameter


Thanks

Narsi

Hi, i wants more details about how the multiple instances job will work ,if iam going to call same job with diffrent parameters for each instances, like what in terms of harware usage of diffrent instances, and any performance imapact if we create multiple instances of dsjob. please one can send me ...

i hope u have done find and replace dsx file.that is the problem

Thanks for your quick reply plz find the those lines =+=+=+= ControlAfterSubr "0" Dependencies "CJobDepend" BEGIN DSSUBRECORD Name "DFSDUPLDDimSkuDSKU" Type "0" END DSSUBRECORD BEGIN DSSUBRECORD Name "DFSDUPLDHASHNEWSKUKEYS" Type "0" END DS...

Hi , while iam importing dsx file iam getting this error Line 63952: Unknown property name '"'. Object=SubObject of ROOT. Class=CParameters. but yesterday iam able to import the dsx file.the problem his after importing 10 jobs iam getting that above warning and it's hanging please any one can h...

Hi , this is input structure year, jan,feb,march,april so.....on dec. and my target structure is totalsales,periodkey input values are year,jan,feb,march...dec 2006 200 300 400 .... 500 target should be periodkey totalsales 2006jan 200 2006feb 300 please any one can hepl me Thanks

please look into these below code iam not able genrate new key even a_key-------->column having null ,it should genrate key. do u think technically any problem in below code iam not able genrate new keys If isNULL(a_key) Then (DSLink10.max_loc_Key + KeyMgtGetNextValue(DSJobStartTimestamp)) Else DSLi...

Thanks
for my gr8 friend

no buddy i got the answer if you wants pass user defined name for tmu file. in that case first run the job without passing any name for tmu it will genrate default name. and rename that file which name u want and use that name in u r job and run it it will creating tmu file. it means it's should exp...

Really you so sweet man i like you so much the way which you answering for my small doubts


please send me that awk code first i have to resolve these issue i will start learning qwk tomorrow onwards please send me that code


Thanks

:-):)

do u have that awk code if u have please help me

Thanks for your great help

You too smart please da.... why don't you recall for me how to implment without using piviot.. i tried whole fourum but no technique all are telling use pivot. please help me da if you are able to recall it's really helpful for me...

:-)

yes i don't have pivot stage please can tell me how to implment
with out using pivot

Thanks

I have requirment like this my inputs structure is

loc-key,code_key,year,totsales,,jan,feb.....dec but out put ssould be in this format


loc_key,codekey,year,jan,tosales

lockey,codkey,year,feb,totsales

Using Transformer how to implment please can any one help me

Thanks