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.

Could you explain what is enterprise data warehouse?

1148

---

differences between service based and product based?

2016

---

Explain sql transformation in script mode examples in informatica

1136

---

What is union transformation?

965

---

-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?

5794

---

What are the databases that informatica can connect to windows?

1054

---

What does command task mean?

1155

---

Name at least 5 different types of transformations used in mapping design and state the use of each.?

1160

---

What is xml source qualifier transformation in informatica?

1217

---

How do we call shell scripts from informatica?

1121

---

Explain scd type 3 through mapping.

1011

---

in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use

2038

---

What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?

2365

---

What are the tasks that can be performed using sq?

1093

---

In informatica workflow manager, how many repositories can be created?

1363

---