thanks ,,,,,,,no it's not a home work

its again an interview question but I got an answer already...

this can be done using a corelated query

SELECT DISTINCT (a.age) FROM test55 A...

Thanks ,I am a little bit clear now.

Thanks....I did google it, but was more confused with the results and hence wanted a general yet simple answer to the question that can be given in an interview.

http://www.geekinterview.com/kb/Data-Optimization.html

In this...

Thanks

Hi,

Creating test data is becoming problematic as its getting very confusing.

Let me explain the complete scenario first :

(Please be patient..it will go long)

We have a details table from where I...

ok then let me create some test insert statement, I will reply soon

Thanks but, I cannot use it in a subquery as I have to store the Level value in a variable and then have to add a LOOP to generate...

yes, it is dynamically passed ,the list of column is passed through a parameter

it is dynamic sql, Can be any column in the table like Age ,Salary, Name, Address,...

your synax is missing some condition here:

SELECT

CSP.Provider_Address1,

CSP.Provider_Address2,

CSP.Provider_City,

CSP.Provider_State,

CSP.Provider_Zip,

CSP.Provider_County,

CSP.Provider_Email,

CSP.Provider_Web_Addr

FROM dbo.CMD_Staging_Providers CSP

INNER JOIN dbo.Providers P

ON P.Provider_NPI = CSP.Provider_NPI#

AND P.Provider_Tax_ID = CSP.Provider_TAXID

WHERE CSP.Has_Errors = 0 AND

CSP.Provider_Address1 NOT IN ( SELECT Street FROM...

I don't understand how this applies to my given data...??

In my given data is there any way to do this..

Please let me know a way to do this using my...

why would you want to lookup all the columns as you need only the dimension KEY in the fact table...you can just lookup the business key and the primary key...

Hi,

thanks for your reply

-I got a way to do what I was trying to in this useful link

but now I was using a File System task (instead of SCRIPT task...

You can create an excel file with separate sheets for easch package and paste a screenshot of your package then below that expalin what every task does.

In BIDS you can use EPT to run a package, but in SSA, you require to create a JOB to run a package,

Try creating a job first then , Start...

This is simple..

You have to use a SORT transformation and de-duplicate on LOOKUP columns.

You can remove duplicates either before using lookup Tx or after that before inserting into your destination.