Can you pass sql queries in filter transformation?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More Data Warehouse General Interview Questions

In my report contain product name, amount, country, sales person I want to create one prompt: sales territory.( Ex: asia, us, uk, aus), but territory column is not there in my model and source if u select the asia in prompt page-ll asian country results I want in report page I discussed with my friends and colleague, they told use the static choice function still I face this problem. If u know please tell me?

0 Answers  


Explain how are the dimension tables designed?

0 Answers  


Explain what are snapshots? What are materialized views & where do we use them? What is a materialized view log?

0 Answers  


What is vldb(very large databases)?

0 Answers  


Can we start and stop single session in concurent bstch?

0 Answers  






What is your spectra photometer working principles?

0 Answers  


What is confirmed dimension?

7 Answers   JPMorgan Chase,


Why null values are mapped as 0 in fact tables?

0 Answers  


What are the different methods of loading dimension tables?

0 Answers  


What is Data purging?

8 Answers   TCS,


Hi, Could any one tell me which schema (star and snow flake schema) will take much space? Thanks S.A.K

6 Answers   Accenture, IBM, TCS,


DWH architecture?

6 Answers  


Categories