data extraction

[vireshkolagimat]

Hi All,

I have two tables namely Master and transaction table. What is the best way to extract date from these tables.

1. Write the sql query in SSMS and use the same sql query in Qlikview edit script  to get the data OR

2.  Extract individual table first and create the qvd file and  join both the tables in the edit script?

Thank you.

Regards,

Viresh

[avkeep01]

Hi Viresh,

Depeding on the performance of the SQL server u could use the SQL query, If it is slow, then use step 2. Because in step 2 you'll load the data twice.

[YoussefBelloum]

Hi,

I think this, is the best way to do it (a best practice),

have a look: Three Tier Architecture