Answer / ravi satyadarshi

//1st of all create a directory to store ur external table
CREATE DIRECORY EMP_DIR AS '/FLAT_FILES' ;


// now write the following line of code to create an
external table at that directory

CREATE TABLE OLDEMP(ENO NUMBER,ENAME CHAR(20),DOB DATE,)
ORGANIZATION EXTERNAL
( TYPE ORACLE_LOADER
DEFAULT DIRECTORY EMP_DIR
ACCESS PARAMETERS
(RECORDS DELIMITED BY NEWLINE
BADFILE 'BAD_EMP')
LOGFILE 'LOG_EMP'
FIELDS TERMINATED BY ','
(ENO CHAR , ENAME CHAR DOB CHAR DATE_FORMAT
DATE MASK "DD-MON-YYYY"
)
)
LOCATION ('EMP1.TXT')
)
PARALLEL 5
REJECT LIMIT 200;

Can you have a nested transaction?

1 Answers  

---

explain detail about ftp in datastage?

0 Answers   IBM,

---

If a column is an image value type, how you can compare column values? How can you use this column in join clause?

0 Answers  

---

The count() function always returns a int value type what should you do if you need to count rows from a query which you know will return a value that is too large for an int value type?

0 Answers  

---

What is normalization? Explain different levels of normalization?

8 Answers   CG-VAK, Choice Solutions, College School Exams Tests, IBM, Wipro,

---

What are the main phases of database development?

0 Answers  

---

Write short notes on manual refreshes.

0 Answers  

---

Write the fastest query to find out how many rows exist in a table?

0 Answers  

---

What is bit datatype and what's the information that can be stored inside a bit column?

2 Answers  

---

How can you log an error to the server event log from a stored procedure?

0 Answers  

---

Write short notes on XSU and JAVA

1 Answers  

---

What is denormalization and when would you go for it?

9 Answers   NBP,

---