Select empno, count (*) from EMP group by empno having count (*)>1;
Subscribe to:
Post Comments (Atom)
your turn hear
Popular Posts
-
The naming convention for variables is: v_ 1. A variable name should be easy to read and convey the purpose of the variable. This help...
-
If we copy source definaltions or target definations or mapplets from Shared folder to any other folders that will become a shortcut. Let’s...
-
If target and source databases are different and target table volume is high it contains some millions of records in this scenario without...
-
Split the non-key columns to separate tables with key column in both Scenario 2: Split the non-key columns to separate t... -
M ANAGING THE E NGINE The development and production engines shall be managed by the Informatica support Team. Information regar...
-
1 . Bitmap indexes are most appropriate for columns having low distinct values—such as GENDER, MARITAL_STATUS, and RELATION. This ass...
-
A code page contains the encoding to specify characters in a set of one or more languages. An encoding is the assignment of a number to a c...
-
Hi All installing the informatica power center on Windows 7( problems resolved) befoere clicking the setup right click on the setup-...
-
This section describes the different types of triggers: Row Triggers and Statement Triggers BEFORE and AFTER Triggers INSTEA...
-
Simply it performs select statement. Select statement fetches the data in the form of row. Source qualifier will select the data from the s...
No comments:
Post a Comment