In which situation we will use persistant cache and shared cache in real time. plzsss answer with example

1 Answers   Wipro,

---

What is the need for an etl tool?

0 Answers  

---

What is a transaction control transformation?

0 Answers   Informatica,

---

in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use

0 Answers   TCS,

---

sample mappings for scd1,scd2 and scd3

2 Answers   Cognizant,

---

What are 2 modes of data movement in Informatica Server?

1 Answers   Informatica,

---

What are the issues that you have faced while moving your project from the Test Environment to the Production Environment? Please explain in depth thanks in advance

3 Answers  

---

In a mapping i have three dimensions. If i want to pass a same surrogate key value to all the three dimensions by using one sequence generator is possible?If the mapping is containing single flow? And in the same case if the mapping is contaning 3 flows for the three dimensions then by using one sequence generator can we populate surrogate key (same value) to all the three dimensions?

6 Answers   IBM,

---

I am hvaing SOURCE as first line: 1000,null,null,null second line as:null,2000,null,null 3rd line as :null,null,3000,null and final line as: null,null,null,4000 ............................Now i want the OUTPUT as 1000,2000,3000,4000 For more clarification i want to elimate nulls and want in a single line. Please help me out

2 Answers   IBM,

---

hOW CAN WE DELETE A RECORD OR TRUNCATE IN TARGET TABLE USING SQL T/R ?

4 Answers  

---

How can yoU improve session performance in aggregator transformation?

8 Answers   TCS,

---

Explain the types of transformations?

0 Answers  

---