Answer / anilchandu

Instead of writing complex logics in expression t/r we will
use Stored procedure t/r.

The main advantage of stored procedure t/r is the code
reusability.

Answer / swetha

For populating and maintaining data bases.

Answer / rajbir

We use stored procedure transformation top evalate the
expression for rows at database level so that we can use it
again n again according to our requirment

Answer / madhu

For best performance

What is the difference between Junk and Confirmed Dimention? where can be used htat one in Informatica?

3 Answers  

---

how to get max value record into one target and remaining records into another target?

2 Answers   Accenture,

---

write sql query following table amount year quarter 1000 2003 first 2000 2003 second 3000 2003 third 4000 2003 fourth 5000 2004 first 6000 2004 second 7000 2004 third 8000 2004 fourth i want the output year q1_amount q2_amount q3_amount q4_amount 2003 1000 2000 3000 4000 2004 5000 6000 7000 8000

1 Answers   HP,

---

Can i create a lookup table without cache.

7 Answers   iGate,

---

Why should we use star schema in datawarehouse design?

2 Answers   Wipro,

---

How we can use union transformation?

0 Answers  

---

Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?

0 Answers  

---

There are 4 flat files with number of records as indicated below. Which files should be picked first for joining using joiners so as to get best performance. File A - 1000 records File B - 100 records File c - 10000 records File D - 10 records Please explain. Thanks and Regards,

1 Answers   Amdocs,

---

where is the reject loader .

1 Answers  

---

i have source like X1 10 X2 20 X1 30 X2 40 i want target as X1 X2 10 20 30 40 in informatica

2 Answers   HP,

---

What is log file,and where is it located,why u r using the log file

1 Answers   TCS,

---

How can informatica be used for an organization?

0 Answers  

---