Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

can u give example for factless fact table

Question Posted / info.baireddy

Answers were Sorted based on User's Feedback



can u give example for factless fact table..

Answer / srinivasulu raju

Factless fact table is used to track the Events.

Eg: Attendance System.

Is This Answer Correct ?    7 Yes 0 No

can u give example for factless fact table..

Answer / ankit kansal

Take two dimensions as dim_time and dim_product and
a fact table as fact_sales
Now provide a reference from both of the dim tables to the fact table and while loading from the source do not load any other data.
Now you can easily report out
product sold per day
product sold per month
product sold per year
e.t.c.

deepinopensource.blogspot.in

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Informatica Interview Questions

What are Rapid changing dimensions?

1 Answers  

without table how to come first record only in oracle?

0 Answers  

How would you join a node to the already existing domain?

0 Answers  

what are the limitations of pushdown optimization technique ? Advance thanks

3 Answers   Puma,

What is difference between maplet and reusable transformation?

2 Answers  

How can we trouble shoot the commas in a column of a comma delimited flat file in Informatica

1 Answers  

In Datastage, we have row generator stage to generate dummy row. Is there any such transformation in Informatica. Thanks in advance, Kumar

1 Answers  

Is there any target staging area in informatica not staging area

0 Answers   Syntel,

What is parameter file?

2 Answers  

waht is dataware house

2 Answers  

what is pre and post sql and what is diff between source presql and target pre sql

1 Answers   HCL, IBM,

what is flat file override?

1 Answers   Cap Gemini, HP,

For more Informatica Interview Questions Click Here
Categories