Interested to Buy Any Domain ? << Click Here >> for more details...
How the facts will be loaded? explain
- 2 Answers
- 8104 Views
- HCL, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / naveen kumar reddy
LOADING FACTS
The most important thing about loading fact tables is that
first you need to load dimension tables and then according
to the specification the fact tables.
The fact table is often located in the center of a star
schema, surrounded by dimension tables. It has two types of
columns: those containing facts and other containing foreign
keys to dimension tables.
* A typical fact table consists of: Measurements:
additive-measures that can be added across all dimensions ,
non-additive cannot be added and semi-additive can be added
across few dimensions.
* Metrics
* Facts - The fact table has frequently more than one
measurement field and then each field is called a fact.
Usually one fact table has at least three dimension tables.
Note:
Found this answer at http://www.etltools.org/loading/facts.html
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / venkat
If all dimention tables are succeded then only you can load
data in to the facts.if any one of the dimention is not
filled you cannot load data into the fact tables.Fact table
size can be calculated based on the lowest level
granularity of dimention tables.
| Is This Answer Correct ? | 2 Yes | 5 No |
how to convert the .doc docs into .txt format using informatica
What is a router transformation?
What is workflow manager?
how i will stop my workflow after 10 errors
How to fix the etl bugs..Tell me the process?
If a session fails after loading of 10,000 records in to the target.How can you load the records from 10001?
rank() over (partition by opt2.dim_plat_site_id, opt2.dim_site_opt_sid order by case when opt2.dm_market_flg in ('Y', 'U') then 1 else 2 end, lkp.contact_rank) as rank1, case opt2.contact_type when 'Buyer' then row_number() over (partition by opt2.dim_plat_site_id, opt2.dim_site_opt_sid, lkp.contact_rank order by has_name_flg desc, ship_to_flg desc , last_order_dt desc) when 'Decision Maker' then row_number() over (partition by opt2.dim_plat_site_id, opt2.dim_site_opt_sid, lkp.contact_rank order by has_name_flg desc , last_quote_dt desc , mailability_score desc , source_ranking desc) when 'Influencer' then row_number() over (partition by opt2.dim_plat_site_id, opt2.dim_site_opt_sid, lkp.contact_rank order by has_name_flg desc, mailability_score desc, source_ranking desc) when 'Payer' then row_number() over (partition by opt2.dim_plat_site_id, opt2.dim_site_opt_sid, lkp.contact_rank order by has_name_flg desc, mailability_score desc, source_ranking desc) --elu 05/28/2013 else row_number() over (partition by opt2.dim_plat_site_id, opt2.dim_site_opt_sid, lkp.contact_rank order by has_name_flg desc, mailability_score desc, source_ranking desc) end rank2 row_number() over (partition by opt3.dim_plat_site_id, opt3.dim_site_opt_sid order by rank1,rank2) as "rank", case when "rank"<= opt3.maximum_value then 'Y' else 'N' end as include_flg
Comment on significance of oracle 9i in informatica when compared to oracle 8 or 8i?
Write the unconnected lookup syntax?
what are types of dimentions?
What do think which one is the better joiner or look up?
tell me the informatica architecture
Teradata 
