how the data will be loaded while desiging the schema?which
one first (for e.g.-dimesions and facts)
- 2 Answers
- 5359 Views
- Sonata, I also Faced
- E-Mail Answers
Answer Posted / suraj kedia
The order of loading the schema is as below:
1)Dimension Table
2)fact table
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
how we can load rejected record's at run time?(not through bad files)
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
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 parallel processing in informatica?
What is a joiner transformation?
What is dimensional table?
Explain your project of banking domian.
Write the unconnected lookup syntax and how to return more than one column.
What is rank index in rank transformation?
can u any challenge your project?
Please let me know how to make encryption and decryption with example?
Briefly describe lookup transformation?
what is the Default Source Option For Update Strategy Transformation?
Explain target update override in informatica
What is the procedure for creating independent data marts from informatica 7.1?
