Write a query to display Which deptno is containing highest Sal > avg (sum (Sal)) of all deptno; Avg (sum (Sal)) o f all deptno= 9675 Deptno, sum (Sal) 10 8750 20 10875 30 9400

7 Answers   iGate,

---

How can you display only hidden files in UNIX

4 Answers   Cognizant, L&T,

---

1)what is the use of bottlenecks in informatica. 2)where we are use shellscripting. 3)what meant by informatica.

1 Answers   CTS,

---

What are the types of lookup transformation?

0 Answers   Informatica,

---

In which scenario did u used Mapping variable?

1 Answers   Cognizant,

---

I have a text file name x With a text message. Word informatica Is repeated for n number of times. How to count the number of occurrence Of word informatica Of word informatic in this file x.

1 Answers   Wipro,

---

Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?

0 Answers  

---

Which means the first record should come as last record and last record should come as first record and load into the target file?

0 Answers   Informatica,

---

Hi all, i am new to this site and new to Informatica too. I have few questions regarding that. 1) When we load flat files into target tables how do we identify duplicates? and where do load the duplicate records for further reference? 2) How do we do chage data capture? Is this Slowly changing Dimension technique? Thanks in Advance

3 Answers  

---

in what type of scenario bulk loading and normal loading we use?

2 Answers   Cognizant, Wipro,

---

Partition, what happens if the specified key range is shorter and longer

0 Answers   Cap Gemini,

---

We can't use sql override or other properties when using Flat file as source. Then what is the use of Source Qualifier transformation?

3 Answers  

---