Answer / swetha

Join data originating from same source data base.

Filter records when the informatica server reads source data.

Specify an outer join rather than the default inner join

specify sorted records.

Select only distinct values from the source.

Creating custom query to issue a special SELECT statement
for the informatica server to read source data.

What is the difference between a table and the materialized view?

2 Answers  

---

Consider two cases: (1) Power Center Server and Client on the same machine (2) Power Center Sever and Client on the different machines what is the basic difference in these two setups and which is recommended?

2 Answers  

---

"Change cache" in Informatica ?

2 Answers  

---

performance tuning of Informatica

1 Answers  

---

What did you do in source pre load stored procedure

1 Answers  

---

If source is having 5000 rows,and if you want to load data into 500 rows to target,if the session runs successfully,how can you verify the target if the rows are successfully loaded or not.

3 Answers   IBM, TCS,

---

In a table there are 1 million records there in which 3 records are duplicate how will you find out those 3 records?

6 Answers  

---

why union transformation is active transformation?

6 Answers   IndiGo, TCS,

---

Are there any types of Dynamic Caches in informatica

4 Answers   Accenture,

---

I've an excel sheet, in which one column contains data about the location like "City, State" and few columns contains only "State". Now I wanna load into my target City and State into two different columns. Pls help me out...

6 Answers   TCS,

---

what is constraint based load order

2 Answers   Cap Gemini,

---

What is mapplet in informatica?

0 Answers  

---