Interested to Buy Any Domain ? << Click Here >> for more details...
can u give example for factless fact table
- 2 Answers
- 6446 Views
- TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / srinivasulu raju
Factless fact table is used to track the Events.
Eg: Attendance System.
| Is This Answer Correct ? | 7 Yes | 0 No |
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 |
explain abt ur project architecture?
0 Answers Anthem, DELL, IBM, TCS, Wipro,
Where should yoU place the flat file to import the flat file defintion to the designer?
Hi Experts , Can you please help me regarding the below question How to remove first three rows and last three rows in informatica.. thanks and regards Natraj
how to create user defined function (udf) in informatica
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
What is hash partition?
How do you manage the Parameter files while migrating your data from one environment to another environment?
I have source table 100 records after run session successfully but loads the target table 50 records only what happened that 50 records and how can i load remaining 50 records
when do we use static cache and when do we use dynamic cache in lookup transformation? with example.
What is the function of aggregator transformation?
What if the source is a flat-file? Then how can we remove the duplicates from flat file source?
Explain incremental aggregation in informatica
Teradata 
