Answer Posted / manshul goel
FOR EACH is considered as a "group by" in the SQL generated
while when we apply FOR ALL it generates SUMMARY on the
basis of the element
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
what is parallel query?
Explain what are the modules in power mart?
What are various warehousing tools?
What are templates in which way it is help full?
What is data warehouse architecture?
Theare is a Database In analysis services,How we will specify the fact table.(i.e whether we will create the measure objects for the fact tbl.) or it will reside insde the database.
What is the purpose of cluster analysis in data warehousing?
Explain the difference between filter and conditin?
What are the different types of datawarehosuing?
What are Aggregate tables?
What is the use of dimensional modeling in data warehousing?
What is the difference between olap and oltp?
What are the advantages of raid 1, 1/0, and 5. What type of raid setup would you put your tx logs?
What is an IDQ file? What is the purpose of the IDQ file and what kindof information does it usualy hold? Can it be imported by informatica?
Suppose if a session fails after loading of 10,000 records in to the target.how can you load the records from 10001 the record when you run the session next time?