Interested to Buy Any Domain ? << Click Here >> for more details...
how many data models u have done in informatica project?
- 2 Answers
- 8144 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / prabhu
As an informatica developer you will not mostly work in
Data modelling.It would be handled by seperate team like
DBA team
Prabhu
www.iskilltech.com
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is meant by pre and post session shell command?
What does command task mean?
What are the different options available for update strategy?
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
How to implement security measures using repository manager?
Why do you use Mapping Parameter and mapping variable?
explain abt ur project architecture?
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
How to handle decimal places while importing a flatfile into informatica?
What is the need of an ETL tool?
What is the difference between writing a joiner query in ANSI style and THETA style?
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 a mapplet/worklet in informatica?
Explain the types of transformations?
What is decode in static cache?
