Answer Posted / venkateshmalneni

FOR THIS WE HAVE 2 USE TWO T/R ie FIRST WE HAVE 2 USE RANK T/R
AND THEN USE A FILTER T/R IN FILTER GIVE THE CONDITION AS
RANK=5 CONNECT TO TARGET
THE FLOW IS LIKE THIS
SRC --->SQ--->RANK--->FILTER--->TRG

WE CAN ALSO DO THIS IN SQL USE THE FOLLOWING QUERY

SELECT * FROM <TABLE_NAME> WHERE ROWNUM <= 5 MINUS SELECT *
FROM <TABLE_NAME> WHERE ROWNUM <=4;

What are the main issues while working with flat files as source and as targets ?

1160

---

What is repository manager?

989

---

What is the function of aggregator transformation?

1085

---

Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar

2745

---

Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps

2036

---

Suppose we do not group by on any ports of the aggregator what will be the output?

1041

---

How you know when to use a static cache and dynamic cache in lookup transformation?

1855

---

what are the different types of transformation available in informatica. And what are the mostly used ones among them?

1064

---

Is it possible to create multiple domains on a single Informatica server?

1240

---

How many ways are there to do 'remove duplicate records in informatica'?

1014

---

Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?

2120

---

Tell me about MD5 functions in informatica

929

---

What are the types of caches in lookup? Explain them.

970

---

What is the difference between stop and abort in informatica

1097

---

What is a code page?

1177

---