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.

sir presently i am persuing my m.tech recently i got job in tcs as fresher presently iam doing my 9 months project related to informatica can any one guide me how to create fact tables what type of schemas must be used and so on if so give ur mail ids so that i can contct through it

1 Answers  

---

What is a filter transformation?

0 Answers  

---

Source table ------------- ID NAME --- ------ 101 PANKAJ NULL KUMAR NULL MATHUR 102 JYOTI NULL SAXENA 103 SACHIN NULL TENDULKAR TARGET TABLE ------------- ID NAME --- ------- 101 PANKAJ KUMAR MATHUR 102 JYOTI SAXENA 103 SACHIN TENDULKAR IN ORACLE & INFORMATICA LEVEL HOW TO ACHIVE

2 Answers   Wipro,

---

Can anyone tell me the new features in Informatica 9 Version?

0 Answers   Syntel,

---

What happens to map if we alter the datatypes between source and its corresponding source qualifier?

0 Answers  

---

---

In a table, 4 person having same salary. How to get Third person record only?

15 Answers  

---

How do you create single lookup transformation using multiple tables?

6 Answers   TCS,

---

When will u go for (which means situation) Connected Lookup and Connected Lookup? Pls explain with an example?

5 Answers  

---

I have a text file name x With a text message. Word informatica Is repeated for n number of times. How to count the number of occurrence Of word informatica Of word informatic in this file x.

1 Answers   Wipro,

---

What are the new features of the server manager in the informatica 5.0?

1 Answers  

---

can we see default group,when we use router?if yes how?

2 Answers   L&T,

---

Whats the difference between $, $$, $$$

9 Answers  

---