Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / lokesh y g
maplet is reusable transfromation,suppose same
tranfromation using different mapings ,for this perpose
create tranformations in maplet that maplet we can use any
maping.but same logic we need to use ..........
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
Can we get 1st record through Informatica(without sequence number).
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
How do you update the records with or without using update strategy?
What the difference is between a database, a data warehouse and a data mart?
How many ways a relational source definition can be updated and what are they?
Explain the different lookup methods used in informatica?
what is diff b/t sorter t/r and agg have the option sorter property...
How to start a workflow using pmcmd command?
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
What are mapplets? How is it different from a Reusable Transformation?
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
How are indexes created after completing the load process?
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
What is the difference between writing a joiner query in ANSI style and THETA style?
