Search found 80 matches

by kkumardatastage
Tue Dec 22, 2009 1:11 pm
Forum: IBM QualityStage
Topic: Test Environement for Match Designer
Replies: 3
Views: 3395

Test Environement for Match Designer

Hi Please help me in this issue. i am using the matc Designer with 3 pass, in test environment i gave the proper Samle Information as Data Sample Data Set with specified file, and i gave the Frequency Information Data Frequency Data Set with Maximum Frequency Value 100 and i specified a Data Set fil...
by kkumardatastage
Mon Dec 21, 2009 7:33 pm
Forum: IBM QualityStage
Topic: Blocking and matching
Replies: 2
Views: 2050

Blocking and matching

Hi

Please Help me in this issue.

I am using a column First Name as blocking in pass 1, and i would like to use the same column First Name for matching in the same pass 1, is it good way to do the Matching and Blocking for the same column.

Thanks
k
by kkumardatastage
Thu Dec 17, 2009 4:41 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Job aborted
Replies: 3
Views: 1953

path to check oracle log error

Hi
Following is the path to check the oracle errors but we need to have admin access to enter into this path.

/opt/IBM/InformationServer/Server/Scratch

Thanks
K
by kkumardatastage
Fri Dec 11, 2009 10:57 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: 32 mil Records
Replies: 4
Views: 1388

Take MP and DA data in 2 different links and join based on qsMatchSetID. Hi i have done the same thing but i got the following output and i am missing linkages please help me right now i got the following Output format MP DA MP DA BUT I NEED TO GET THE ACTUAL OUTPUT WITH FOLLOWING FORMAT MP DA MP D...
by kkumardatastage
Fri Dec 11, 2009 8:50 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: 32 mil Records
Replies: 4
Views: 1388

32 mil Records

Input(32 MIL records) Please can any one help me in designing a job that get the following output. - in input the qsMatchSetID show you the group of records by giving a value i.e 1,2,3,4 if SetID got same Number like 1 then this all 1 should be consider as a group so Consider the input got 3 rows as...
by kkumardatastage
Thu Dec 10, 2009 4:11 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Job aborted
Replies: 3
Views: 1953

Job aborted

Hi Please can any one help me with this issue i got the following error message in Director log for a job. job i am loading a data set to a table by creating a new table, the data is loading perfectly but the job log show the following error. ----: The system(sqlldr CONTROL=ora.10194.96295.0.ctl LOG...
by kkumardatastage
Mon Dec 07, 2009 5:30 pm
Forum: IBM QualityStage
Topic: m-prob and u-prob in QS
Replies: 2
Views: 2555

m-prob and u-prob in QS

Hi Please can any one help me, 1)what is meant by m-prob and U-prob in quality stage match designer, I know the default value we need to give but what will this effect to data. Please if u got some example that will be great. 2)what is the minimum and maximum Cutoff we can use for Match and Clerical...
by kkumardatastage
Thu Dec 03, 2009 2:32 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Unix DS&QS
Replies: 1
Views: 1032

Unix DS&QS

Hi

Please can any one help me in this issue i got some file under this path i dont know what are they.

/opt/IBM/InformationServer/Server/PXEngine/bin/osh -APT_PMsectionLeaderFlag mtt

Help me

Thanks
k
by kkumardatastage
Wed Dec 02, 2009 2:46 pm
Forum: IBM QualityStage
Topic: Match Designer
Replies: 6
Views: 3276

Hi I got one question for you in match designer i am using two Dataset as source to get the Match pairs, one dataset is used to Sample Information and other dataset is used for Frequency information(whcih is generated in previous job). 1) But my question is why do we need to use the Test Results dat...
by kkumardatastage
Mon Nov 30, 2009 5:41 pm
Forum: IBM QualityStage
Topic: Match Designer
Replies: 6
Views: 3276

HI Thanks for your reply, The database Test connection is good and the Configuration file i used to test the Match designer is default & 1 node CF both are working good and the Test been complited but I could not see the Result and Statistics for any of the Passes with same error's. please can a...
by kkumardatastage
Mon Nov 30, 2009 5:16 pm
Forum: IBM QualityStage
Topic: Match Designer
Replies: 6
Views: 3276

Match Designer

Hi i got one issue with my Match Designer, i created 4 passes and i tested all passes, Test been complited but i got one error, Following is the error in Match Designer and I could not see the Result and Statistics for any of the Passes are inactive. Please can any one help me in this issue. Error1:...
by kkumardatastage
Mon Nov 30, 2009 4:46 pm
Forum: IBM QualityStage
Topic: Match Designer - table or view does not exist
Replies: 1
Views: 1411

Match Designer - table or view does not exist

Hi i got one issue with my Match Designer, i created 4 passes and i tested all passes, Test been complited but i got one error, Following is the error in Match Designer Please can any one help me in this issue. Error formatting result table query: [DataDirect][ODBC Oracle Wire Protocol driver][Oracl...
by kkumardatastage
Tue Nov 24, 2009 4:44 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Getting director log for job in text file
Replies: 2
Views: 1175

I got the solution for this Following is the solution: login to Datastage director go into the log of the particular job Ex:PXjob_KKKKK select project from menu go to print option select All entries(in Range) Select Full details(in Print what) Print quality(High) check box Pint to file select ok and...
by kkumardatastage
Mon Nov 23, 2009 3:52 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Error Running OSH: Out of string space(14)
Replies: 0
Views: 2012

Error Running OSH: Out of string space(14)

Hi Please can any one help me in this issue i got the following issue with my Match Designer, I created a Match Pass and i am doing Test All pass --->save specification-->Tested the connection for ODBC(Oracle DB) and the configuration file i am using is defalt and i got the input file, Frequence fil...
by kkumardatastage
Mon Nov 23, 2009 10:10 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Unusable Index Issue
Replies: 12
Views: 4840

Thanks

Thanks for your help.

i solved this issue using Job param as APT_ORACLE_LOAD_OPTIONS = OPTIONS(DIRECT=FALSE,PARALLEL=FALSE)