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.

Differentiate between source qualifier and filter transformation?

1564

---

I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .

1928

---

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

1247

---

What is meant by a domain?

1111

---

How would you join a node to the already existing domain?

1111

---

waht type of interface is used for testing the data in informatica

2238

---

What is update strategy transform?

1078

---

how to create user defined function (udf) in informatica

1288

---

What is blocking transformation?

1126

---

I have a flat file, want to reverse the contents of the flat file

1109

---

Explain constraint based loading in informatica

1076

---

What is persistent lookup cache?

1015

---

What are the components of workflow manager?

1074

---

Explain joiner transformation in informatica

1109

---

In development project what is the process to follow for an etl developer from day1

1701

---