Answer / sabyasachi

Some of theOracle Analytical functions are like DENSE_RANK
(), RANK(),CUM_DIST(),CUM_AVG() etc. One get the
fuctionalities of some of these functions such as rank by
using a rank transformation.

For other types of functions one can resort to custom
transformation.

in reporting we add some new objects,how we get the count of the newly added objects to the report

0 Answers   HP,

---

What is diff between connected and unconnected lookup?

5 Answers   BirlaSoft, Blue Star Infotech,

---

Hi can any one tell me the difference between persistence and dynamic caches? On which conditions we are using these caches?

3 Answers  

---

can we use self join in informaitca?

3 Answers   IBM,

---

In dimension and fact table? which one holds big data?

2 Answers  

---

Hi gurus can any one tell me with a flow how to implement SCD Type 1 and SCD Type 2 in a single mapping.For some fields SCD type has to be implemented and for some fields scd type has to be implementd..Thank in advance....

1 Answers  

---

what are the difference between Informatica 7.1 and 8.1?

6 Answers  

---

How to load relational source into file target?

3 Answers   IBM,

---

How many joins in Informatica

5 Answers   CSC,

---

In how many ways we can create ports?

0 Answers  

---

If informatica has its scheduler why using third party scheduler?

0 Answers  

---

I have table with ID,PRD_DT,PRD_FLAG,CUST_DT,CUST_FLAG I need to get max date and its corresponding flag for both the date columns. Ex:- 1A,10/3/2015,AC,10/3/2015,XY 1A,10/4/2015,AB,10/2/2015,XZ Output needed 1A,10/4/2015,10/3/2015,XY I have 100 million + in the table so avoid self-join...

2 Answers   Amex,

---