If you are unable to create a new account, please email support@bspsoftware.com

 

How to implment JOIN operation in datamanager

Started by LEO, 14 Jul 2011 11:14:16 PM

Previous topic - Next topic

LEO

I have some columns in 1 data source and some columns coming from another data source. Both the source tables have same number of records in it.

These all columns i want to insert into 1 single target table.

While executing the build, it's simply appending the rows(rows from source1 followed by rows from query2).

Actual number of rows in target should b equal to numbe of rows in source table but the count is becoming twice.

Its simply appending the rows..

can anybody help in implementing this.

MFGF

Hi,

Go to the properties of the fact table delivery in your build, and on the Table Properties tab firstly identify all the key values which together make each row unique. Then on the Module Properties tab change the refresh type of the delivery from Append to Update Insert.

Make sure you empty the table before running the build to remove all the duplicate rows.

Regards,

MF.
Meep!