Interested to Buy Any Domain ? << Click Here >> for more details...
I cleared Informatica certification Designer. if anybody
need dumps, can contact at mukesh1009@gmail.com
- 119 Answers
- 120541 Views
- Accenture, Gcs, TCS, I also Faced
- E-Mail Answers
Answer Posted / ramesh
Hi Mukesh,
Pls Can u send me the dumps to my mail id:
ramesh.718@gmail.com
It will helpful to me.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Explain target update override in informatica
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
Have you worked with/created Parameter file
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
What are the basic requirements to join two sources in a source qualifier transformation using default join?
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
where to store informatica rejected data?
What are the modules in Power Center
what is song in infrmatica...?
What is the use of code page?
Can you use flat files in Mapplets.
What is decode in static cache?
What is pmcmd command?
What you know about transaction control transformation?
