Answer Posted / suman

Instead of Join use subquery

What is joiner transformation in informatica?

995

---

What are connected or unconnected transformations?

1051

---

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?

1445

---

How to Create a folder using pmrep command?

1107

---

what are the different types of transformation available in informatica. And what are the mostly used ones among them?

966

---

Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?

993

---

What are the types of presistent cache in look up tr.

2009

---

Explain the scenario which compels informatica server to reject files?

1091

---

5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C

1845

---

Explain the mapping variable usage example in informatica

1087

---

What is the use of an aggregator cache file?

1144

---

What are the mapping parameters and mapping variables?

1090

---

What is InformaticaPowerCenter?

1077

---

what are 3 tech challenges/ common issues you face?

2282

---

The question was on time stamp. what is the difference between HH and HH24 when to use when.

1996

---