Answer / ankur saini

i think we cant use target , seq etc in the mapplets
becuase this will restrict the basic need for which
mapplets are, that is re-usability...if you are using same
target then it wouldnt be reusable right. Mapplet is a set
of trancformations you use to load diff targets i would say.

same is the case with seq generator ..say you have a maplet
with a seq gen ...this is being used in two diff
mappings...then that seq gen will generate one set or seq
no for one mapping and anothe set for other mapping say
1,2,3 for first mapping and 4,5,6 for 2nd mapping but this
is not reusablitiy!!!!

Answer / srinu

If it allows Target and other transformations instead of
mapplet we can very well use Mapping.

Mapplet nothing but(parameter concept) set of
transformation logic you can use for similar kind of
mappings and save your time.

how do u move the code from development to production?

6 Answers  

---

Hi If i had source like unique & duplicate records like 1,1,2,3,3,4 then i want load unique records in one target like 2,4 and i want load duplicate records like 1,1,3,3 then can any body please send me what is th scnario. my mail i shek.inform@gmail.com

6 Answers   HCL, Schneider,

---

Could any one to tell How to use the Oracle Analytic functions in Informatica?

1 Answers  

---

write s sql query following table some duplicate present i want unique one column duplicate another column display? name id a 1 a 1 b 2 b 2 c 3 i want the required output like unique duplicate name id name id a 1 a 1 b 2 b 2 c 3

4 Answers   Bank Of America,

---

Hi ETL gurus can any one tell me with a flow how to implement SCD Type 1 and SCD Type 2 in a single mapping.For some fields SCD type has to be implemented and for some fields scd type has to be implementd..Thank in advance..please let me know in case of any concerns...

1 Answers  

---

source target Q410 4 2010 Q311 3 2011 Q412 4 2012 Q309 3 2009

1 Answers   IBM,

---

I have one source table and three target tables. When the session runs for the first time involving the mapping,i want that the loading should take place in 1st Target table only. The 2nd time the same session runs the loading should take place in 2nd Target only only and similarly when the session runs for the 3rd time loading should take place in Third only. And again when the session runs for the 4th time loading should take place in 1st Target table.

4 Answers   Cap Gemini, IBM,

---

List the transformation used for the following: (1) Heterogeneous Sources (2) Homogeneous Sources (3) Find the 5 highest paid employees within a dept. (4) Create a Summary table (5) Generate surrogate keys

1 Answers  

---

Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?

0 Answers   HCL,

---

How to load only the first and last record of a flat file into the target?

3 Answers   Mind Tree,

---

1)what is the use of bottlenecks in informatica. 2)where we are use shellscripting. 3)what meant by informatica.

1 Answers   CTS,

---

write a query to get maximum salary from the employers table without duplicates....kindly help me

5 Answers   CTS,

---