Answer Posted / ravi

MAPPLET IS SET OF REUSABLE TRANSFORMATION,WE CAN USE THIS MAPPLET IN ANY MAPPING WITH IN THE FOLDER
WHERE AS REUSABLE TRANSFORMATION IS SINGLE TRANSFORMATION,WE CAN USE MANY TIMES
*) IF WE CREATE MAPPING VAR OR PARAMETERS IN MAPPLET WE CAN'T USE IN ANOTHER MAPPING (OR) MAPPLET.
WHERE AS *) IF WE CREATE MAPPING VAR OR PARAMETERS IN REUSABLE WE CAN USE IN ANOTHER MAPPING (OR) MAPPLET.
*) IF YOU USE A STORED PROCEDURE TRANSFORMATION, YOU MUST CONFIGURE THE STORED PROCEDURE TYPE TO BE NORMAL.
YOU CANNOT INCLUDE THE FOLLOWING OBJECTS IN A MAPPLET:
1) NORMALIZER T/R
2) COBOL SOURCE
3)XML SOURCE QUALIFIER T/R.
4)XML SOURCE
5) TARGET DEFINITION

What are mapplets? How is it different from a Reusable Transformation?

1032

---

How to improve the performance of a session using sorter transformation?

1092

---

What is the difference between a connected look up and unconnected lookup?

910

---

Write the advantages of partitioning a session?

1204

---

Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?

1195

---

What is a pre-defined event and user-defined event?

972

---

How we can create indexes after completing the load process?

1108

---

Differentiate between source qualifier and filter transformation?

1509

---

What is the difference between informatics 7x and 8x and what is latest version?

1023

---

Explain the aggregator transformation?

1093

---

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 ?

2306

---

Slowly changing dimensions, types and where will you use them

1654

---

tell me 5 session failure in real time how can you solve that in your project?

2184

---

What do mean by local and global repository?

1151

---

what is the Default Source Option For Update Strategy Transformation?

1166

---