Unix and Oracle

read--------------------- http://docs.oracle.com/cd/B28359_01/server.111/b28294/toc.htm Read more

Read---------------------- http://docs.oracle.com/cd/E11882_01/server.112/e40540/cncptdba.htm#CNCPT827 Read more

Read----------------------- http://www.thegeekstuff.com/2013/08/oracle-rman-backup/ Read more

Read------------------ http://docs.oracle.com/cd/B28359_01/backup.111/b28270/rcmcncpt.htm Read more

Read----------------------------- http://www.orafaq.com/books/certification Read more

Read------------------------------------ http://www.oracle-base.com/dba/script.php?category=monitoring&file=access.sql Read more

Read..................................... http://education.oracle.com/pls/web_prod-plq-dad/db_pages.getpage?page_id=146 Read more

Read........................................... http://www.webopedia.com/TERM/O/Oracle_OCP_DBA.html Read more

Anything that opens a file, can open a read only file: cat, more, less, awk, pg, et all. The chmod command you put does not make a file read only, it makes it read/write for the user/owner. Read more

Read........................... http://www.folkstalk.com/2012/06/connect-to-oracle-database-in-unix.html Read more

Read----------------------------- http://www.dba-oracle.com/t_batch_shell_scripting.htm Read more

Read.......................... http://www.oracle-base.com/articles/misc/oracle-shell-scripting.php Read more

nw=`cat filename|cut -f  -d `|sed -i "s/$nw/ Read more

while [ ! -z "$1" ] do mv "$1" "$1.new" done Read more

Please open this link and read................ http://www.a2zinterviews.com/DataWarehousing/datastage/ Read more

Question: Dimension Modeling types along with their significance Answer: Data Modelling is broadly classified into 2 types. A) E-R Diagrams (Entity - Relatioships). B) Dimensional Modelling. Question: Dimensional modelling is again sub divided into 2 types. Ans… Read more

1) Define Data Stage? A data stage is basically a tool that is used to design, develop and execute various applications to fill multiple tables in data warehouse or data marts. It is a program forWindows servers that extracts data from databases and change them in… Read more

Changes/Enhancements in IBM Datastage 8.5, 8.7 and 9.1 1. Design & Runtime Performance Changes: DS8.5: Implemented by Internal code change. Design and Runtime performance is better than 8.1, 40% performance improvement in job open, save, compile etc. … Read more

1. in 8.5 transformer options llike (do- while) available in looping structure but not available in 7.5  2.in 7.5 can set the single parameter using environment variable but parameter set options are available in ds8.5 and patameter set means collection of variable… Read more

The main difference is that DataStage has gone from being a standalone ETL tool to part of the Information Server. So you cannot install DataStage without including the Metadata Server and components that go with it. ***************************** i have crea… Read more