Answer Posted / srikanth

select * from table where rownum<=30

minus

select * from table where rownum<=21;

COM components can be used in Informatica

2454

---

What is the need of etl tools?

1181

---

how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?

7179

---

What are the modules in Power Center

1718

---

How do you load only null records into target?

1252

---

What is union transformation?

1015

---

Is there any way to read the ms excel datas directly into informatica?

1068

---

1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?

2171

---

Define Pmrep command?

1114

---

How do you convert single row from source into three rows into target?

1213

---

Differences between connected and unconnected lookup?

1271

---

What are the different components of powercenter?

1113

---

Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance

2105

---

What is meant by lookup transformation?

1181

---

What are the validations that you can perform in oracle and in informatica ? Advance Thanks

2127

---