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.

By using Transformation i need top most 5 employee salary from each deptwise? Deptno 10,20,30? which transformation we need to use?

8 Answers  

---

What will happen when Mapping variable and Mapping parameter is not defined or given? Where do you use mapping variable and mapping parameter?

10 Answers   Deloitte,

---

how can we calculate fact table size?

1 Answers  

---

in my source table i want to delete first and last records and load in between records into target? how can it possible?

3 Answers   HCL, Thomson Reuters,

---

Which means the first record should come as last record and last record should come as first record and load into the target file?

0 Answers   Informatica,

---

What is the difference between unicode & ascii mode data movement in informatica?

1 Answers   TCS,

---

Suppose we have a (assume relational) source table Product_Id Month Sales 1 Jan x 1 Feb x . . . . . . 1 Dec x 2 Jan x 2 Feb x . . . . . . 2 Dec x 3 Jan x 3 Feb x . . . . . . 3 Dec x . . . . . . and so on. Assume that there could be any number of product keys and for each product key the sales figures (denoted by 'x' are stored for each of the 12 months from Jan to Dec). So we want the result in the target table in the following form. Product_id Jan Feb March.. Dec 1 x x x x 2 x x x x 3 x x x x . . So how will you design the ETL mapping for this case , explain in temrs of transformations.

5 Answers   Accenture, VAMA,

---

source file name xyz a,0,a,a,a b,b,b,0,b c,c,c,0,c target should be like this xyz a b c how to implement this?

4 Answers   Polaris,

---

what is mean by flag 4 in update strategy t/r

6 Answers  

---

What are the types of lookup?

3 Answers   Wipro,

---

I cleared Informatica certification Designer. if anybody need dumps, can contact at mukesh1009@gmail.com

119 Answers   Accenture, Gcs, TCS,

---

How do you implement scheduling in Informatica?

1 Answers  

---