Answer Posted / ankit kansal

The Problem asked about deleting rows using SQL T/R...

So write a sql query like
Delete from table name where col_name = ?input_port?

This is how u will be able to delete a particular row using SQL trans..

http://deepinopensource.blogspot.in/

How union transformation is used?

1006

---

What is meant by a domain?

1128

---

Enlist the advantages of informatica.

1068

---

What are session parameters ? How do you set them?

1850

---

How many number of sessions can one group in batches?

1157

---

What is meant by incremental aggregation?

1106

---

which one is better performance wise joiner or look up

1093

---

What are the types of schemas we have in data warehouse and what are the difference between them?

941

---

How does the aggregator transformation handle null values?

1149

---

What are the main issues while working with flat files as source and as targets ?

1162

---

What is a connected transformation?

1119

---

How many input parameters can exist in an unconnected lookup?

1545

---

I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?

1767

---

What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?

1079

---

What is the difference between informatica 7.0 and 8.0?

1016

---