Answer / ravi

Mapplet:this is a set of transformation that can be made
reusable.Reusable T/F is a single transformation which can
be made reusable.
Parameter and variable defined in Mapplet can not be used
in other mapping or mapplets but which defined in reusable
T.F can be used in other mappings/mapplets.
cobol,normalizer,xml can not be used in mapplet but they
can be made reusable.

Answer / mahesh

Mapplet consists of set of transformations that is
reusable. A reusable transformation is a
single transformation that can be reusable.

can we use union transformation in joiner transformation?how?

1 Answers   Dabur, Tech Mahindra,

---

How to write a procedure for a date which is in three different formats,and you want to load into datawarehouse in any single date formate

2 Answers   AHM,

---

What are the data movement modes in informatcia?

3 Answers  

---

What is an incremental loading? in which situations we will use incremental loading

2 Answers   HCL,

---

Hi All, I have three question. 1) How to remove the header and footer in a flat file in informatica? 2)How to load the first and last record of flat file into the target? 3)I have a Input and Output table. Input Name Salaray Month A 100 Jan A 200 Feb A 300 March B 400 April B 500 May B 600 June Output Name Salaray Month A 100 Jan A 300 Feb A 600 March B 400 April B 900 May B 1500 June How to implement and get the ouput as mentioned above. If Possible kindly provide the SQL query also. Kindly any one help to implement this concept. Thanks, Pradeep

3 Answers   CSC, iNautix,

---

Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?

2 Answers  

---

Explain scd type 3 through mapping.

0 Answers  

---

What is up date strategy and what are the options for update strategy?

2 Answers  

---

i having mapping emp---> sq_emp--->target using this mapping i have to load dept table values into target... (condition assume there is no primary and foreign key relation between emp(table x) and dept (table Y))

5 Answers   Cap Gemini,

---

What is a command that used to run a batch?

2 Answers  

---

In Which scenario did u used Incremental loading?

2 Answers  

---

performance wise which one is better in joiner and lookup transformation?why?explain clearly?

4 Answers   IBM,

---