Answer / Vivek Soni

{"substr": "A function in Informatica PowerCenter that extracts a substring from a larger string based on start and length positions."}

What is the approximate size of data warehouse?

6 Answers   Accenture, i3 Solutions,

---

we have 20 records in source system, when we run for the 1st time, it should load only 10 records into the target, when you run for the second time it should load another 10 record which are not loaded. How do we do that? Can we write a SQL query in source qualifier to do it. This q' is asked in one f the interviews. Please let me know if anyone knows. Thanks

3 Answers   TCS,

---

if i have one mapping and we already tuned that mapping for performance,everything is fine and loading will take 1 hr,so without doing any change in mapping how could we reduce the loading time from 1hr to 1/2 hr.

5 Answers   Wipro,

---

Is it possible to use a client with different version than that of its Informatica server?

1 Answers  

---

what is the difference between Informatica7.1 & informatica 8.1

4 Answers  

---

What are the different lookup cache(s)?

1 Answers  

---

What are the different types of olap? Give an example?

1 Answers  

---

how lookup is acting as both active and passive ? how is it possitble?

9 Answers   TCS,

---

what is mystery dimension?

1 Answers  

---

When the informatica server marks that a batch is failed?

2 Answers  

---

If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me

1 Answers   IBM, TCS,

---

Can we make worklet inside worklet?

1 Answers  

---