Answer Posted / rakesh

while using the option sorted input, we must have to use sorter t/r before joiner to send the sorted data to the joiner.

How can we delete duplicate rows from flat files?

745

---

How to extract the informatica rejected data?

757

---

What is the Rank index port in Rank transformation?

672

---

How do we call shell scripts from informatica?

599

---

How do you handle two sessions in Informatica

669

---

---

Performance tuning( what you did in performance tuning)

1489

---

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?

1055

---

Differentiate between sessions and batches?

574

---

What is a node in Informatica?

628

---

can any one explain about dataflow in the informatica project for bank domain....thanks is advance

10280

---

Explain the use of aggregator cache file?

678

---

Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.

2327

---

What are the types of schemas we have in data warehouse.

531

---

Describe expression transformation?

636

---

What are the tasks that can be performed using sq?

615

---