Answer Posted / rajesh kumar

We can create mapping parameters and variables in mapping designer/mapplet designer.
We can define the value within the transformation

What are the restrictions of union transformation?

672

---

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

728

---

What is an expression transformation in informatica?

634

---

How are the sources and targets definitions imported in informatica designer?

771

---

How can we use mapping variables in informatica?

682

---

---

is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?

728

---

Which means the first record should come as last record and last record should come as first record and load into the target file?

695

---

pmscmd startworkflow -sv -d -u -p -f while running this command I got the error as "no gateway connectivity is provided for your domain name". So anyone please help me how to rectify this error?

1163

---

Explain the use of aggregator cache file?

799

---

Whats there in global repository

1347

---

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

5141

---

If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?

8929

---

What are the components of workflow manager?

675

---

Explain dynamic target flat file name generation in informatica

732

---

Can we create multiple integration service on single repository?

803

---