Answer Posted / sarvesh

if it is flat file ur answer is write,if it is relational
souce then go to source qualifier properties there u write
the query like
select distinct a.* from t1 a where 10=(select sal from
t1 b where a.sal>b.sal)
i think it is working

What does refresh system mean, and what are its distinctive choice?

1186

---

what is the difference between informatica6.1 and infomatica7.1

2280

---

Mention few power centre client applications with their basic purpose?

951

---

According to his methodology what all you need before you build a datawarehouse

1759

---

What is the use of target designer?

1056

---

What is workflow monitor?

1062

---

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

2125

---

What are the different types of olap? Give an example?

1057

---

If informatica has its scheduler why using third party scheduler?

1268

---

lookup transformation with screenshots

4006

---

How to generate sequence numbers?

1090

---

What happens when a session fails and you click on recover?

1120

---

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

1147

---

How to do the error handling of if ur source is flatfiles?

1968

---

What is meant by target load plan?

974

---