Answer / shashiall

Run the procedure to load the ttime dimension.Its not
loaded frequently,but once or twice a year.

What is the difference between Connected and UnConnected Lookup Transformation.Give me one or two examples please?

7 Answers  

---

In a sequential batch can u run the session if previous session fails?

3 Answers  

---

how to create user defined function (udf) in informatica

0 Answers   Informatica,

---

how we do performence tuning in informatica

3 Answers  

---

what is constraint based loading

2 Answers   IBM,

---

While using update strategy in the mapping which gives more performance, a flat file or Table? Why? What are the advantages and disadvantages?

4 Answers  

---

my session have to run Monday to Saturday not run sunday how to sedule in informatica level?

1 Answers   Infinite Computer Solutions,

---

Write a query to display Which deptno is containing highest Sal > avg (sum (Sal)) of all deptno; Avg (sum (Sal)) o f all deptno= 9675 Deptno, sum (Sal) 10 8750 20 10875 30 9400

7 Answers   iGate,

---

in which situations do u go for starflake schema ?

6 Answers   TCS,

---

permutations of mapplet

0 Answers   TCS,

---

If sal is null then replace it with min(sal). Can any one write a query for this in oracle ? Advance Thanks

7 Answers   Puma,

---

Converting Rows to columns I have Relational source like his. JAN FEB MAR APR 100 200 300 400 500 600 700 800 900 100 200 300 I need to convert these rows into columns to the targe. MONTH TOTAL JAN 1500 FEB 900 MAR 1200 APR 1500 Please experts help me

5 Answers   HP,

---