Answer / Priyanshu Kaushik

A Joiner transformation in Informatica is used to merge data from multiple sources into a single output stream, based on specified join conditions. It is considered an active transformation because it requires processing during runtime, unlike passive transformations that only perform operations like filtering or sorting.

On lookup on any table we can get only a)any value or b)last value but if i need both duplicate values How can i achieve?

3 Answers  

---

pmscmd startworkflow -sv <host name> -d <domain name> -u <user name> -p <password> -f <folder name> <workflow name> 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?

1 Answers   HCL,

---

COM components can be used in Informatica

1 Answers  

---

What is primary and backup node?

1 Answers  

---

Differentiate between Load Manager and DTM?

1 Answers  

---

what are the types of facts with Examples?

3 Answers  

---

I have Employee table, 10 cols are connected to next transformation, only 4 cols are selected in SQL override. What would be passed to next col.

5 Answers   BirlaSoft,

---

if we have a delimiters at unwanted places in a flat file how can we over come those.

1 Answers  

---

If sal is null then replace it with min(sal). Can any one write a query for this in oracle ? Advance Thanks

7 Answers   Puma,

---

Plz can any one say me how to get the informatica certification materials and dumps

1 Answers   TCS,

---

What is the Difference between DSS & OLTP?

5 Answers  

---

we have 20 records in source system, when we run for the 1st time, it should load only 10 records into the target, when you run for the second time it should load another 10 record which are not loaded. How do we do that? Can we write a SQL query in source qualifier to do it. This q' is asked in one f the interviews. Please let me know if anyone knows. Thanks

3 Answers   TCS,

---