Answer Posted / suresh

1.mapplet is a set of reusable transformations,we can use
multiple times
reusable transformations is a single transformation, that
we can used multiple times
2. in mapplet the transformation logic is hide
3.if u create any mapping variables or parameters in
mapplet that can't be used in another mapping or mapplet
unlike if u create in reusable transformation u can use in
another mapplet or mapping

4. we cant include source definition in reusable
transformation.but we can include source to mapplet

5. we cant use cobol source qualifier,joiner,normalizer
transformations in mapplet.

Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.

2403

---

Can we create a Integration service without a Repository service and vice versa?

1257

---

How many transformations can be used in mapplets.

1983

---

what is degenerated dimension?

4093

---

Explain the use of aggregator cache file?

1317

---

What is a node in Informatica?

1086

---

Implementation methodology

1772

---

what are 3 tech challenges/ common issues you face?

2395

---

What is a dimensional model?

1033

---

Is it possible to define a single node as a Gateway node as well as worker node?

1184

---

Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?

1846

---

Explain how to import oracle sequence into informatica?

1071

---

what is the hint? how to use it to reduce the query processing in program?

7975

---

What is lookup transformation?

1093

---

-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?

5879

---