|
|
|
AbInitio
|
|
|
|
ABINITIO TUTORIAL
|
|
3. ETL AND BI NEED DIAGRAM
Click on the image to enlarge
|
|
4. DATAWARE HOUSING ETL NEED DIAGRAM
Click on the image to enlarge
|
|
5. QUERY TO FIND OUT THE NUMBER OF ROWS IN ALL THE TABLES
|
QUERY TO FIND OUT THE NUMBER OF ROWS IN ALL THE TABLES IN THE SQL SERVER |
|
SELECT OBJECT_NAME(id), rowcntFROM SYSINDEXES
Where OBJECTPROPERTY(id,’isUserTable’) =1 and INDID <2
ORDER BY rowcnt Desc
|
|
QUERY TO FIND OUT THE NUMBER OF ROWS IN ALL THE TABLES IN THE ORACLE SERVER |
|
SELECT table_name, num_rows FROM (SELECT table_name, num_rowsFROM ALL_TABLES
WHERE owner = 'USER'
AND last_analyzed IS NOT NULL
ORDER BY num_rows DESC)
|
|
IN THE ABOVE SCRIPT U NEED TO CHANGE THE USER |
|
|
|
|
|
 Training Schedules
|
