Flow of SD and MM

Suppose there is a secondary index on 4 non-key fields A,B,C & D. There are 3 select queries :- a) one on basis of A, B, C , D b) Second on basis of A, B, C c) Third on basis of D, C,B, A In which all situations , the above secondary index will be used?

SCD2 will work on only dimension tables as well as fact Table?

Explain me ETL project architecture in Detail?

Find out BEP(Rupees) when p/v ratio is 40% , MOS is 30%. Profit is Rs 12000

Write all test cases for Bus Pass Renewal

At 6'o a clock ticks 6 times. The time between first and last ticks is 30 seconds. How long does it tick at 12'o clock.

Complete the Table given below: Three football teams are there. Given below is the group table. Fill in the x's Played Won Lost Draw Goals For Goals Against A 2 2 x x x 1 B 2 x x 1 2 4 C 2 x x x 3 7

There N stations on a railroad. After adding X stations on the rail route 46 additional tickets have to be printed. Find N and X.

Given that April 1 is tuesday. A, B, C are 3 persons told that their farewell party was on � A - May 8, thursday � B - May 10,tuesday � C - June 5, friday Out of A, B, C only one made a completetly true statement concerning date,day and month The other told two one told the day right and the other the date right.. What is correct date, month, day.

The Bulls, Pacers, Lakers and Jazz ran for a contest. Anup, Sujit, John made the following statements regarding results. � Anup said either Bulls or Jazz will definitely win � Sujit said he is confident that Bulls will not win � John said he is confident that neither Jazz nor Lakers will win When the result cameit was found that only one of the above three had made a correct statement. Who has made the correct statement and who has won the contest.

Five people A ,B ,C ,D ,E are related to each other. Four of them make one true statement each as follows. (i) B is my father's brother. (ii) E is my mother-in-law. (iii)C is my son-in-law's brother (iv)A is my brother's wife.

Some statements are given below: � L says all of my other four friends have money � M says that P said that exactly one among them has money � N says that L said that precisely two among them have money � O says that M said that three of the others have money � P, L and N said that they have money All the above statement are false.. Who has money & who doesn't have any money?

Replace each letter by a digit. Each letter must be represented by the same digit and no beginning letter of a word can be 0. O N E O N E O N E O N E ------- T E N

Ann, Boobie, Cathy and Dave are at their monthly business meeting. Their occupations are author, biologist, chemist and doctor, but not necessarily in that order. Dave just told the biologist that Cathy was on her way with doughnuts. Ann is sitting across from the doctor and next to the chemist. The doctor was thinking that Boobie was a goofy name for parent's to choose,but didn't say anything. What is each person's occupation?