Answer Posted / chandrasekar

Hi Venkatesh,

The above SQL query is not working correctly..

I have one answer for the above problem. The query is, try
it in the SQL override.

select * from emp where sal=(select max(sal) from emp a
where (select count(sal) from emp b where b.sal >=a.sal)=5)

If it wrong means send the correct answers to me
chandranmca2007@gmail.com

In warehouses how many schemas are there?

1010

---

Explain direct and indirect flat file loading (source file type) - informatica

1262

---

What are the advantages of informatica?

957

---

Describe the impact of several join conditions and join order in a joiner transformation?

1008

---

what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?

2237

---

Explain the types of transformations?

1005

---

What is the fact table?

993

---

What is persistent lookup cache?

966

---

Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.

2350

---

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

1075

---

Performance tuning in UNIX for informatica mappings?

2506

---

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

2688

---

What are ETL Tools?

1040

---

hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica

2028

---

Whats the difference between informatica powercenter server, repositoryserver and repository?

1112

---