Interested to Buy Any Domain ? << Click Here >> for more details...
can u give example for factless fact table
- 2 Answers
- 6665 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 |
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
write a sql query following table some duplicate present 1 1 2 2 3 3 4 5 i want the output unique one column duplicate another column following format like unique duplicate 1 1 2 2 3 3 4 5
,if we have single SQ in flow and we have router in which it has two group and we want to join these two groups with joiner ?is it possible?
there is a comma separated flat file as source and there is a column in that one field is having space like "rama krishna" like that what happens when this is used as source
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b,the target shd be loaded as 1 a+b+c or 1 a||b||c, what transformations shd be used for this?
What are the mapings that we use for slowly changing dimension table?
how we can add header and footer to flat files?
2 Answers Tech Mahindra, Zensar,
What is the difference between informatics 7x and 8x and what is latest version?
when will we use unconnected & connected lookup? How it will effect on the performance of mapping?
explain one complex mapping with logic? sales project?
0 Answers Accenture, JPMorgan Chase,
I have been working in Informix-4gl for the past 2 years in an MNC company.But I'm interested to work in Business Intelligence tools. Is it possible to change the technology now? I'm really confused, please help me
how to load duplicate row in a target
Teradata 
