lookups Image

lookups

question
tlenzmeier avatar image
tlenzmeier asked Default

What's the best method for looking up dates in SSIS for a fact table?

ssis datawarehouse lookups

0 Likes

0Answers

0 Comments

question
johnsmith avatar image
johnsmith edited Default

Archive lookup table

ssis lookups

0 Likes

1Answer

1 Comment

question
GPO avatar image
GPO edited Default

Slowly Changing Dimension - Lookup/Union All

ssis lookups union-all slowly-changing-dimension

This question has an accepted answer. Accepted

0 Likes

1Answer

0 Comments

question
siugoalie78 avatar image
siugoalie78 commented Default

SSIS Lookup no match default value

ssis lookups

This question has an accepted answer. Accepted

1 Like

1Answer

0 Comments

question
James_Chandler avatar image
James_Chandler commented Default

SSRS 2012: Find percentage between numbers from different datasets

ssrs-2012 lookups datase

0 Likes

0Answers

1 Comment

question
GPO avatar image
GPO answered Default

Deploy view or use function for lookup

performance functions lookups

1 Like

1Answer

0 Comments

question
Squirrel avatar image
Squirrel answered Default

Create column that looks up and calculates based on a previous value

sql-server-2012 column lookups calculated-column

This question has an accepted answer. Accepted

0 Likes

1Answer

0 Comments

question
Pavel Pawlowski avatar image
Pavel Pawlowski edited Default

SSIS data being imported into destination different than returned by Lookup transformation

ssis lookups

This question has an accepted answer. Accepted

0 Likes

1Answer

1 Comment

question
TelepathicSheep2 avatar image
TelepathicSheep2 asked Default

SSRS 2008 Reporting Question - Include 'month' filter in YTD Calculation

ssrs-2008 lookups

0 Likes

0Answers

0 Comments

question
KenJ avatar image
KenJ commented Default

How can we update 10 tables by comparing with a text file using packages in ssis 2008?

ssis package lookups foreach-loop

This question has an accepted answer. Accepted

3 Likes

1Answer

0 Comments

question
Usman Butt avatar image
Usman Butt converted comment to answer Default

Lookup Table not working

tsql lookups binary

This question has an accepted answer. Accepted

1 Like

1Answer

3 Comments

question
Jaco Briers avatar image
Jaco Briers edited Default

Why use an int as a lookup table's primary key?

sql-server primary-key lookups

This question has an accepted answer. Accepted

2 Likes

6Answers

0 Comments

question
Gary P avatar image
Gary P asked Default

How do I use "friendly" field names in a query against raw imported data fields?

query import-data lookups

This question has an accepted answer. Accepted

0 Likes

1Answer

0 Comments

question
Fatherjack avatar image
Fatherjack edited Default

Using a lookup table "date value" as variable in SSIS package

ssis variable lookups

0 Likes

1Answer

0 Comments

question
Wendy avatar image
Wendy asked Default

Lookup Table Basics

lookups

This question has an accepted answer. Accepted

2 Likes

2Answers

2 Comments

18 Posts
17 Users
0 Followers

Topic Experts

There are currently no experts identified for this topic. Can you answer questions in this topic area? Community members who provide answers that are marked as correct earn reputation and may become recognized as topic experts.