↳
Prepare everything before going for an interview.
↳
I have answered the question as per my work experience.
↳
They were not really intrested in answers this interview was for fun.
↳
Star and Snowflake. Based on requirement the schema is selected. But if you have choice Star is preferred considering it's performance efficiency as fact is directly connected to dimension tables. Moins
↳
Load, Partial load (Add / Replace), Incremental load, Generic load, Binary load, Residential load Moins
↳
To determine the relative records w.r.t to a particular field these funcitons are used . Denoted by P(Expression) and E(Expression). Moins
↳
Honestly and as accurately as possible while providing examples