Answer Posted / abhishek

U can achive this by using row_number function in source
qualifer example

select col1,col2,salary,emp_id from (select
col,col2,salary,emp_id , row_number() over (partition by
salary order by emp_id )as rec_seq from table)
Where
rec_seq=3

or by rank t/r in mapping

How can we create index after completion of load process?

1163

---

What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?

1250

---

What are the differences between a connected lookup and unconnected lookup?

1124

---

What are the conditions needed to improve the performance of informatica aggregator transformation?

1139

---

In how many ways we can create ports?

1157

---

list out all the transformations which use cache?

1239

---

What is meant by incremental aggregation?

1182

---

Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?

8261

---

I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.

1688

---

Is it possible to use a client with different version than that of its Informatica server?

1189

---

How to join three sources using joiner? Explain though mapping flow.

1189

---

I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?

1122

---

Explain the code page compatibility?

1117

---

waht type of interface is used for testing the data in informatica

2296

---

Can anyone tell me the new features in Informatica 9 Version?

2206

---