DSXchange

Hi

i have a dobut on the datastagge (test 415) certifcation pass score.

The site says total question : 79 (approx)
Pass Score : 75


Is it 75 /79 or 75%

75/79 is 95% and a tough nut to crack...

Please let me know if its 75% or 75

We upgraded to DSEE 7.5.1A this morning. We have a standalone osh scripts that run directly from command line, and when trying to run the first of these we get the following error: ##I TFCN 000001 20:07:25(000) <main_program> Ascential DataStage(tm) Enterprise Edition 7.5.1A Copyright (c) 2004, 1997...

We upgraded to DSEE 7.5.1A this morning. We have a standalone osh scripts that run directly from command line, and when trying to run the first of these we get the following error: ##I TFCN 000001 20:07:25(000) <main_program> Ascential DataStage(tm) Enterprise Edition 7.5.1A Copyright (c) 2004, 1997...

is this the same thing found under the home directory of the project. we have something like this in the ph file &PH&: DSD.OshMonitor_1227_13680 DSD.OshMonitor_16690_13737 DSD.OshMonitor_21857_13692 DSD.OshMonitor_30154_13405 DSD.OshMonitor_35325_13353 DSD.OshMonitor_39773_13521 DSD.OshMonit...

where exactly is this directlyory under the installation?

instead of join u can use a change cpature stage..but still i will explain join

in join stage if u specify lef outer then

for the unmatched records, value will be null for columns originating from the right..

better email me..i can send u the export.

i explained in the post above..

if still unclear mail me at bitnbyte @ gmail

i can send u the job export in ver 7.5

Here is ur file ID,POS 1,A 1,A 1,A 1,A 2,B 2,C 3,D 3,D 3,D 4,C Now to identify single occurence records like 4,C use an aggregator stage. In the stage specify the group as ID Aggregation type: count rows give some name to output column..say ID_Count Have a transformer after the aggregator and check ...

ok,

give me the details like ur key columns..better give the lay out and tell me what u r trying to do..

its not complicated..if u can give details,i can explain step by step

i tested this and its working..it may not be a elagant solution..but i go with it because i dont like to use stage variables.

Can you try this. use an aggregator on id to filter out the single occurances.since they will be part of the final out put. this identifies records like 4,C now filter out these unique occurances from ur input and then use aggregator again on id and pos and to get records with count=1.this identifie...

ds1user1 wrote:

pavankvk wrote:i have another solution for this problem.i will not use stage variables though.

hth

Its not working that way pavan.

Thanks

i am sorry..i will give another logic..even i realised it just now..thats not duplicate stage,i need to use aggregator

yeah..a simple hash partition should solve this problem...u may lose records with out specifying correct partition options..we had the same problem 2 years ago when we tested the software in test env with single node and had to fix this issue later in uat env whioch is multi node

waht is ur data type in target dataset? if its char are u using any datetostring conversion functions? i ususally get these **** while converting date to a char field using the built in functions and if the format of the input data is not what the function expects,then it outputs a ***** so just che...

i have another solution for this problem.i will not use stage variables though. Since u said ur input will have same IDs and Pos and u need to filter out the odd ones, i suggest you use remove duplicate stage with keys id and pos to identify all the records that you want to keep. Collect them into a...