Answer Posted / ravi

MAPPLET IS SET OF REUSABLE TRANSFORMATION,WE CAN USE THIS MAPPLET IN ANY MAPPING WITH IN THE FOLDER
WHERE AS REUSABLE TRANSFORMATION IS SINGLE TRANSFORMATION,WE CAN USE MANY TIMES
*) IF WE CREATE MAPPING VAR OR PARAMETERS IN MAPPLET WE CAN'T USE IN ANOTHER MAPPING (OR) MAPPLET.
WHERE AS *) IF WE CREATE MAPPING VAR OR PARAMETERS IN REUSABLE WE CAN USE IN ANOTHER MAPPING (OR) MAPPLET.
*) IF YOU USE A STORED PROCEDURE TRANSFORMATION, YOU MUST CONFIGURE THE STORED PROCEDURE TYPE TO BE NORMAL.
YOU CANNOT INCLUDE THE FOLLOWING OBJECTS IN A MAPPLET:
1) NORMALIZER T/R
2) COBOL SOURCE
3)XML SOURCE QUALIFIER T/R.
4)XML SOURCE
5) TARGET DEFINITION

How can you validate all mappings in the repository simultaneously?

762

---

What do you mean by filter transformation?

557

---

EXL informatica Questions

938

---

What is the difference between STOP and ABORT options in Workflow Monitor?

699

---

What do you mean by blocking transformation?

586

---

---

What are the validations that you can perform in oracle and in informatica ? Advance Thanks

1661

---

How would you join a node to the already existing domain?

683

---

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

1533

---

What are the different versions of informatica?

685

---

waht type of interface is used for testing the data in informatica

1837

---

How do you load only null records into target?

742

---

Briefly explain the aggregator transformation?

604

---

What is the format of informatica objects in a repository?

603

---

Explain how many types of dimensions are available in informatica?

598

---

Explain informatica architecture - version 8 / 9

674

---