Answer / sanjay

Informatica issue a status code when it's run the stored
precedure transformation , it is use for error handling of
store procedure .

Answer / usha

Status code provides error handling facility.

write sql query to remove null value following table id name 101 dinesh null jyothi null bharathi 102 suresh null shilpha 103 prakesh null suma i want the output id name 101 dinesh 102 suresh 103 prakesh

5 Answers   Accenture,

---

Aggregator transformation is having fields say a,b,c,d,e group by is enabled on a,b,c with sorted input,How the aggregator transformation process the i/p data?or in which way i/p comes to agg transformation

1 Answers   TCS,

---

Which is better performance wise database or file?How?

2 Answers   TCS,

---

How can you join 3 tables? Why cant you use a single Joiner to join 3 tables.

1 Answers  

---

can we generate reports in informatica ? How?

3 Answers  

---

---

How can we use mapping variables in informatica? Where do we use them?

0 Answers  

---

What is the difference between a router and a filter transformation?

1 Answers   TCS,

---

Differentiate between source qualifier and filter transformation?

0 Answers  

---

What is the default join that source qualifier provides?

3 Answers   Informatica,

---

What are the basic needs to join two sources in a source qualifier?

4 Answers  

---

What is limitations of truncate and load option

1 Answers   Cap Gemini,

---

What happens if the info. Server doesn't find the session parameter in the parameter file?

1 Answers  

---