DSXchange

we have a dimension which has a load_date column, so almost all the rows of the dimension gets updated daily, its a diaily run. What is the database? Oracle 10g Delete the updated records...then bulk load both insert+updates to the database works faster than updates. Else put them in Sequential fil...

Hi, I have a requirement like this . I have a input record like this ID NO COUNTRY PRICE VALIDFROM 9406 123 US 00 1/1/2007 9406 123 US 00 1/1/2004 9406 123 US 00 1/1/2005 Now I want to take latest VALIDFROM and assign VALIDTO as 999/12/31 and remaining records must contain Newprice.Validto - Oldpri...

Hi, wht are the possible ways to improve performance when doing Oracle table updates. i thought of Indexes, splitting up inserts and updates.. let me know any ways to improve the performace, my update job is taking longer time to update the records any help is appreciated. thanks Delete and then bu...

Hi, wht are the possible ways to improve performance when doing Oracle table updates. i thought of Indexes, splitting up inserts and updates.. let me know any ways to improve the performace, my update job is taking longer time to update the records any help is appreciated. thanks Delete and then bu...

hi gurus, tried various ways, but still getting warning. This is what i specified the location of directory in my stage. C:\HashFiles\Hash_File2 iam getting warning as hashfilecreation..Hashed_File_1.DSLink4: DSD.UVOpen mkdbfile: cannot create file C:\HashFiles\hash\DSLink4. plz help me. cheers; abhi

hi gurus, thanks very much. odbc--->hashfilestage. when i browse the hashedfile stage,iam specifying a path where to create the hashfile. iam giving create file. in update action iam giving- clear file before create. but iam getting warning. due to which the data is not dumped from odbc to hashed fi...

hi gurus,
thanks very much.
how can i populate my table from odbc into hashfile.
what should i specify in odbc stage inorder to populate my data into hashfile, and then use hashedfile stage to access that data.
plz help me.

cheer;
abhi

hi gurus, how can i use hashfile. i want to join 2 tables from my database. i used odbc and hash file, when i edit hashfile it promptly asks for universe account name and directory, but my source data is in oracle. how can i connect my hashfile to oracle. can't we use hashfile directly to connect to...

hi gurus, how can i use hashfile. i want to join 2 tables from my database. i used odbc and hash file, when i edit hashfile it promptly asks for universe account name and directory, but my source data is in oracle. how can i connect my hashfile to oracle. can't we use hashfile directly to connect to...

hi, in order to eliminate sort component. in the source stage- selection tab i have given ORDER BY MGR ASC. iam getting error- MISSING EXPRESSION. regarding the second query. iam creating a link from odbc to sort and also loaded the metadata into sort component. why doesn't it load records into sort...

hi, thanks very much. my second query is. source stage- odbc iam connecting the same stage to aggregator and sort. its transferring records to aggregator but not sort component. why is that so happening. i see that its performing aggregation and dumping in to target. i want to sort the record and du...

Hi, odbc----->sort----->odbc iam using sort stage , in the properties tab of sort stage. when i enter IN THE SORT SPECIFICATIONS I ENTERED---MGR ASC. MGR-IS THE I/P COLUMN IN MY SOURCE TABLE. in the target table i can see the data organised by itself, what i mean is that i thought if i enter MGR ASC...

Hi I have installed Datastage Server in AIX unix machine and getting the follwoing problem: When I try to connect from client: Failed to connect to host: 10.208.242.82, project: DDR_PRD (User name and/or password incorrect (80011)) When I try to stop and restart services I am getting the following m...

Hi,
i have given command DOS/C C:\DOCUMENTS AND SETTINGS\ADMINISTRATOR\DESKTOP.

i didn't specify the name of the batch file.i have given path. but i have 3 batch files on desktop.
when i specify the above command iam getting error.
DOS/C IS NOT IN VOC.
plz help me in syntax of command.

cheers;
abhi

Hi, Thanks very much,my team has created 3 batch files. when i see the type it shows windows. can anyone plz specify command for running these batch files from datastage administrator. Actually i read a forum that dsexecute() is usedto run these batch files. my batch file is prjbatch.bat its on desk...