Explain can a dimension table contains numeric values?

967

how can we direct the sql generated to use a specifc table?

924

What is the use of teradata system software?

1036

What is junk dimension? What is the difference between junk dimension and degenerated dimension?

1060

What is the difference between Section and Section using Master/Detail in Cognos 8 Report Studio? I tried these both options many times on lists and crosstabs, but dint find any difference. So please give the answer in detail with example.

4580

How would you write a left join statement to return a result set of movie.title�s and director.name�s?

1029

Explain 4gt switch. Does it have any drawback?

967

How can we create a dynamic column name in cognos?

955

How will you enable or disable caching in the system level and table level?

894

How to allow a dynamic selection of a column for a measure in a chart,without using variable?

990

What are all the types of hierarchies?

1137

what are sas/access and sas/connect? : Sas programming

993

What are the components of Informatica? And what is the purpose of each?

1055

Can you execute macro within another macro? If so, how would sas know where the current macro ended and the new one began? : sas-macro

1199

Explain the datastage parallel extender (px) or enterprise edition (ee)?

1225