What is the grain level in DWH? If i have year to day. what is the grain level

What is the grain level in DWH? If i have year to day. what
is the grain level of DWH from year to day.

Question Posted / manojdubba

What is the grain level in DWH? If i have year to day. what is the grain level of DWH from year to ..

Answer / raj

At What Level the data stored in the data ware house.
day in lowest level grain in the data ware house

Is This Answer Correct ?

5 Yes

1 No

More Informatica Interview Questions

Please explain in detail with example about 1.Confirmed Dimension. 2.Junk Dimension. 3.Degenerated Dimension. 4.Slowly changing Dimensions

What is Micro Strategy? Why is it used for?

Briefly define reusable transformation?

How can yoU create or import flat file definition in to the warehouse designer?

When the informatica server marks that a batch is failed?

explain the scenario for bulk loading and the normal loading option in Informatica Work flow manager ???

How can i catch the Duplicate Rows From SorterTrans in a Seperate Target Table ?

What is an aggregator transformation?

How to eliminate 1st and last rows from the source and load the inbetween rows.

What is rank transform?

How can we join the tables if they don't have primary and foreign key relationship and no matching port?

Have you worked with/created Parameter file

For more Informatica Interview Questions Click Here