how can send duplicate records to one tableand non
duplicate records to one table with simple clear mapping?
- 5 Answers
- 9414 Views
- DELL, I also Faced
- E-Mail Answers
Answer Posted / gopi
For this i have seen one excellent video in YOUTUBE. Please
check this site.
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
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 are session parameters ? How do you set them?
Explain what are the different types of transformation available in informatica.
While importing the relational source definition from the database, what are the metadata of source that will be imported?
How can you increase the performance in joiner transformation?
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
How identifying bottlenecks in various components of informatica and resolving them?
What is dimensional table? Explain the different dimensions.
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
Can you generate sequence numbers without using the sequence generator transformation?
How to elaborate tracing level?
What is the commit type if you have a transaction control transformation in the mapping?
what is informatica metadata?
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
How can we improve session performance in aggregator transformation?
