Input file ----100 records.

A) Using a rollup,how many records will you get?
b) How can I get more than 100 records?
c) How can I get 1 record?

Showing Answers 1 - 6 of 6 Answers

tanay

  • May 24th, 2015
 

Using roll up on null key can give you one record.

  Was this answer useful?  Yes

Bibhu Prasad Behera

  • May 30th, 2015
 

a. Using Rollup ,you can get 100 or less than 100 records.(depending upon the key )
b.Use normalize to get more than 100 records.
c.Use Rollup with null key.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions