Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all
by using of autonumber function i map two fields, original record is near to 320000 when i store in to qvd it duplicated (it has 4.5GB)
I added row no for the show the duplication
i attached sample PFA
Try with DISTINCT
BridgeTable:
IntervalMatch (Date)
Load DISTINCT FromDate,
ToDate
resident TempFact;
You are probably missing an additional key field with IntervalMatch(), maybe constructed using JobNo and DateFinalStatus:
Try with DISTINCT
BridgeTable:
IntervalMatch (Date)
Load DISTINCT FromDate,
ToDate
resident TempFact;
Your Tempfact Join is not necessary.in line 20. This creates a table within a table. Like a forced join. and an Interval ID which you mentioned in the TempFact table in the beginning already.