DSXchange

At universe stage if i view it showing empty source.if i run job running successfully but no rows

Thanks

in both projects having same entry in uvodbc.config file.
and imported table definition example1 from each project but still not able to fetch data from proj2.

Thanks!!

have created two projects proj1 and proj2 on same server.imported prod dsx to both projects both projects sychronized. i have created new job to get list of jobs in project.So created new job in proj1. source query: SELECT DS_JOBS.CATEGORY,DS_JOBS.NAME AS JOB_NAME FROM DS_JOBS universaldatabasestage...

Hi,
have created two projects on same server.in one project in job can able to fetch data from univese database (localuv) from ds_jobs&ds_jobobjects.but in another project i couldnt able to fetch data please help on this.

Thanks

Hi, my production database having fn_hash function. PROMPT FUNCTION fn_hash CREATE OR REPLACE FUNCTION fn_hash(in_str clob) RETURN VARCHAR2 IS BEGIN return DBMS_CRYPTO.HASH (in_str, DBMS_CRYPTO.HASH_SH1); END; / My ETL job calling this function to find delta records. oracleocistage-->lookupwith hash...

Hi, merging two files ,should i need to specify all columns of files in merge stage.if not specify its showing error after running. example file1: c1|c2|c3|c4|c5|c6 file2: d1|d2|d3|d4 outputfile: c1|c2|c3|c4|d1|d2|d3|d4 at merge stage level for first file i didnt specified c5 and c6 at column defini...

Hi,
Please let me how to setup odbc setup for mysql database.which driver i should mention in the odbc.ini file under the dsengine folder.

Thanks
SS..

in my source file i am getting date columns and for target i should pass previous date for those columns.

ex:
frezdate
10/01/2010
01/03/2010

output:
09/01/2010
27/02/2010

like this i want output just previous date i should load for each record.

i want to extract previous timestamp from current timestamp filed in datastage PX.


Thanks
v......

will it possible.if itpossible how to do what are the options i should mention

Hi, i have two fileds in source f1,f2 and in reerence data i have r1,r2 column. first i should lookup f1 and r1 then for matchinf records i should pass r2 .for unmatching records i should lookup f2 with r1 then i should pass r2 for those records.is this one how can i do with singale lookup stage. .....

Thanks a lot its working with CALL statement.

Hi, I created stored procedure in oracle database. create or replace procedure sp_TruncateLandingTable ( itable_name varchar2 ) as l_table varchar2(255); begin l_table := 'truncate table ' || itable_name; dbms_utility.exec_ddl_statement(l_table); end sp_TruncateLandingTable; and in oracle stage open...

Hi, In source folder i have filenames like this FM PRINTVALUE REPORT 022211.txt FM PRINTVALUE REPORT 022311.txt FM PRINTVALUE REPORT 022411.txt in seq file i mentioned with FM*.txt and read method changed to FILEPATTERN. and extracting filename with 'FILE NAME OPTION' in seqfile.but in view data it ...

unable convert time to int32 error getting....