Interested to Buy Any Domain ? << Click Here >> for more details...
Tell me how many tables used in Ur project and how many fact
tables and dimension tables
used in ur project
- 2 Answers
- 7772 Views
- iGate, Qualcomm, I also Faced
- E-Mail Answers
Answer Posted / davankumar
Actuvally...that can be dependinge ur project...but u have
2 say like these..In my project we have more than 100
tables but in my module we can used only 10 to 15 tables
only..
Then dimension :5 to 6 dimension tables
And 1 or 2 fact tables
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What is meant by lookup transformation? Explain the types of lookup transformation?
Differences between version 7.x and 8.x.
How to extract sap data using informatica? What is abap? What are idocs?
What is a pre-defined event and user-defined event?
What are the uses of etl tools?
What is fact table? Explain the different kinds of facts.
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
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
What is main use of mapplet?
How to load a Dimension ? and how to load a fact table?
How do you promote a non-reusable transformation to reusable transformation?
What differs when we choose the sorted input for aggregator transformation?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
How can we use batches?
What is a surrogate key?
