DSXchange

hi, i want to use parameters defined at project level in my source stage. i defined a parameter using datastage administrator. NAME TYPE PROMPT VALUE DBMS TYPE STRING ENTER THE DATABASE NAME in the value - i didn't give any name- i just set to default. when i go to my source stage which is DRS STAGE...

hi,

Thanks very much.
once again thanks.

cheers;
vijay

hi Gurus, i have connected DSLINK4 to DRS STAGE AND DSLINK6 TO SEQUENTIAL FILE. i want all the rejected rows to go to SEQUENTIAL FILE. i specified constraint for this. linkname constraint rejected row abort after rows DSLINK4 DSLINK6.REJECTED 0 DSLINK6 DSLINK3.CITY='Berlin' checked 0 here DSLINK3 is...

hi, my source is sql server target is sql server. my design is iam using DRS stage to connect to SQL server and a transformer stage to perform transformations, and DRS stage as target. i created another link from the transformer stage to sequential file inorder to catch the rejected rows. i specifie...

hi, one of my mate always compares datastage with informatica. he says that he can override the sql statements at session level and at mapping level. i said that u can specify a sql statement in the where tab and if u want one can overide the specified sql statement using a jobparameter. he asked wh...

Hi, what i have analyzed is that by using reporting assistant, we can generate the reports from a developed job or project which is stored in repository. but here the design is different. i want to generate report from dsengine which looks like as much as universe. iam following your advise and want...

Hi gurus; you are always on the top, i feel that a datastage developer in the entire world should come up to the forum inorder to get precise answers. i cannot think without this forum. as ray suggested a reporting assistant. can i dump all the information of jobs, metadata into oracle.when i dump i...

hi sorry i used the different word to describe what we are doing. what we are doing is. source- universe. target-oracle. doing the normal ETl process. i wanted to analyze the data in universe but i used the different word. i never thought that source can be universe too so used that word. plz assist...

Hi, we have compiled the job and saved. even the jobs which have worked fine now facing with peculiar problem. i got a peculiar problem, iam getting error. [data stage][sql clinet][odbc][oracle][odbc][ora]ora-12535. tns operation timed out. plz help me out, we dont have any dba here, and you people ...

Hi, can u provide a link which gives a snap shot of the developed job in datastage which deals with erp packages like peoplesoft. This would be a big favour to me. if u would provide me a link whic has a snap shot view. i have studied the forums and able to analyze but want to show my team lead how ...

hi,
sorry we are in the same group.

cheers;
vijaykumar

Hi guus, i was extracting employee table from the source and passed through aggregator stage and then used odbc to store the data. soure table has columns. target too has the same colums. empno ename salary in the aggregator stage- i want to find the sum of sal. so double click the sal column. in th...

Hi gurus, our company is doing the reverse engineering. dealing with universe- which has developed jobs ,routines, procedures and so on... my initial step is to analyze the objects in the universe. As no documentation is present to give the clear view. you people are gurus helping out the developers...

hi, i could resolve the problem, i didn't configure orahome path. my listener service file was corrupted, i installed with the other one. earlier i was using the microsoft drivers for oracle , replaced with the oracle orahome 92 drivers, what makes these difference. i mean whats make oracle drivers ...

hi, tried hard but couldn't find the $DSHOME DIRECTORY so that i can configure the orahome path. went to c\ascential\engine. could find text folders like UVCONFIG,UV.LOGINS,VOC,UV.ACCOUNT,.UVCONFIG. could find directories like UVTEMP,INCLUDE,DS_LICENSE. getting error - DSR.METADATA[GET.DSNINFO] BCI ...