Answer / swetha

Source name

Database location

Column names

Datatypes

Key constraints

What are the different caches used in informatica?

3 Answers   UST,

---

if suppose i have 3 columns namely 1,2,3 in table a and 1,2,3 in table b Now in table a 1,2 and table b 1,2 columns are having same data.now based on this two columns either data should get inserted or updated. How do i write a sql query to check whether the data is populated correctly or not

2 Answers   Cap Gemini,

---

What is main use of mapplet?

0 Answers  

---

What is mapplet and a reusable transformation?

2 Answers  

---

How can you generate reports in informatica?

0 Answers  

---

List the transformation used for the following: (1) Heterogeneous Sources (2) Homogeneous Sources (3) Find the 5 highest paid employees within a dept. (4) Create a Summary table (5) Generate surrogate keys

1 Answers  

---

What are the performance considerations when working with aggregator transformation?

0 Answers  

---

Which kind of index is preferred in DWH?

3 Answers  

---

In aggregator transformation, I sort the data before aggregator and select sorted port but still I’m getting an error. What is that error?

2 Answers  

---

surrogate keys usage in Oracle and Informatica?

5 Answers   ITC Infotech, Oracle,

---

i have a source of n records.i have to load n+5 records to my target.What is the procedure??????plz tell me.....

1 Answers  

---

What are the advantages of informatica?

0 Answers  

---