halgai

 Profile Answers by halgai Questions by halgai

• Oct 8th, 2007

Design a trap to a file or table by the use of a filter transformation or a router transformation. Router works well for this.

ravi kumar guturi

• Oct 5th, 2005

correction the rejected data and send to target relational tables using loadorder utility. Find out the rejected data by using column indicatior and row indicator.

Answer Question  Select Best Answer

Read Best Answer

Editorial / Best Answer

Answered by: swati

• Nov 5th, 2005

---

star schema consists of single fact table surrounded by some dimensional table.In snowflake schema the dimension tables are connected with some subdimension table.

In starflake  dimensional ables r denormalized,in snowflake dimension tables r normalized.

star schema is used for report generation ,snowflake schema is used for cube.

The advantage of snowflake schema is that the normalized tables r easier to maintain.it also saves the storage space.

The disadvantage of snowflake schema is that it reduces the effectiveness of navigation across the tables due to large no of joins between them.

halgai

 Profile Answers by halgai Questions by halgai

• Oct 8th, 2007

Snowflakes are an addition to the Kimball Dimensional system to enable that system to handle hierarchial data.  When Kimball proposed the dimensional data warehouse it was not first recogonized t...

Richard

• Feb 2nd, 2006

It depends upon the clients which they are following, whether snowflake or star schema.

Improve Answer

Inner equi join.

Aaradhya

• Nov 10th, 2016

The Joiner transformation supports the following join types, which you set in the Properties tab: Normal (Default) Master Outer Detail Outer Full Outer Default join is Normal Join/Inner Join/Equi-Joi...

Vikas Dhakne

• Aug 8th, 2016

Source Qualifier transformation supports following types of joins:
1.Normal/Equi join
2.Left Outer Join
3.Right Outer Join

Answer Question  Select Best Answer