DSXchange

Iam Counting Duplicates To Build Control Report

Yes Iam Sortin Incoming Data On Key Feilds and Have Hash Lookup And Next Transform stage Odbc Lookup , Next Transform Stage iam Countind Duplicate Rows And Finally Loading SQL Server

My Sources Are From CFF

svRowCount = If RowProcCompareWithPreviousValue(Col1 : Col2 : Col3: Col4) = 0 Then "Y" Else "N" And Next Transformation Stage I am Collecteting All N's And Counting. This Is Working Fine, But Job Is Processing 30 Rows Per Seconds. With Out This I am Able To Process 300 Rows Per S...

I am Trying To Count Duplicate Rows Basing On Composite Primary Keys

Thanks
Martin

Hi Kudke,
I Tried ,But In Vain...ICouldn't Find Any. If You Have Any Please Forward
Thanks
Martin

I Am Using RowProcCompareWithPreviousValue Function To Count Duplicates On A Key Feild Job Is Runnig Slow.

Is There Any Other Logoic To Count Duplicates.

Thanks
Martin

Hi Ray,

I tried Your Sujjestions But Same Error.Any Idea Please

Thanks
Martin

I have defined Oracle ODBC Connection And tried to login Into MetaStage Explorer...But Its giving Message...Administrator:User Not Valid. See Your Administrator...Some One Would Please Help How To LogIn

Thanks
Martin

Take Your Col1 Into One StageVariable Ex:var1 And Take Another StageVariable Ex:var2 If Col1(from Ur Input) = var1 Then (var2 + 1) Else 1 Set IntialValue As 0 For var2 In Stage Variable properties. This Is How Counter will Incriment When Ever It Encounter A Duplicate Value In The Column GoodLuck Mar...

Yes....U Can Do This ======>TX=====>Pivot=====>Out Concatnate Transformer[TX] Input Clumns Into One Output Column TX (Input) (Output) col1 col2 "Header" (col1) col3 col1:col2:col3:col4:col5:col6 (col2) col4 "Trailer" (col3) col5 col6 Pivot (Input) (Output) col1 col2 col1,col2,col...

would you please Make Peter Lai's original routines available to the forum

Thanks
martin

Would You Please Educate Us On this Command ..How To use And Where To Use
Thanks

Tony

The Way U Define In JobControl( Flexibility In Using Basic Language)
U Can Write Better Job Sequence..

Invoke Tranform Stage And map All The Columns And Define Below Constraint To Eliminate Last New Line Or Blank Line. But Make Sure You Do this On Key Column or Key Columns Which Doesnt Have Spaces. DSLink.ColumnName > ' ' (Here Take One Key Column) Or (Col1:Col2:Col3:Col4) > ' ' (Here U Can Take Mult...