Answer / karthik

You can increase the loading of query faster in following ways:

Query Optimization (Reducing the complexity in query).
Buffer cache increasing
Using Tier 0 (Flash storage) to increase IOPS.

What is a dimensional model?

0 Answers  

---

What is an incremental loading? in which situations we will use incremental loading

2 Answers   HCL,

---

why we r using presql&postsql in source qualifier?

1 Answers   HP,

---

How do u identify or filter out a 0 byte file available in a folder by using UNIX command?

1 Answers   Wipro,

---

how to get the data from the client machine and how to get server location data to client loction can any body explain to me

1 Answers   TCS,

---

How an expression transformation differs from aggregator transformation?

0 Answers  

---

I have 4 columns in a table say, name ,address, salary and city. So based on distinct city names, i need to combine the other data and send it to a flat file. Distinct city names can be 4 or 5 or 6. So it has to dynamically generate flat files(4 or 5 or 6) corresponding to the city names.

2 Answers  

---

What are teh different tasks that can be created in workflow manager?

1 Answers   NIIT,

---

what is threshold error in informatica?

1 Answers   TCS, Wipro,

---

How to load dimension and fact in same mapping at same time.explain me the logic used for that scenario.

1 Answers   IBM,

---

what is dynamic cashe

3 Answers   Informatica,

---

i have ten flat files with same structure,if i want to load it to single target,and mapping needs to should show only one source.what will be the steps to taken to achieve it?/

5 Answers   L&T,

---