1)What is configuration your file structure
2)I have two databases both are Oracle while loading data
from source to target the job takes 30 min but I want to
load less time how?
Answer Posted / suren
delete the indexes while loading into database.
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Which warehouse using in your datawarehouse
What is the project in datastage?
if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables? how can i implement scd typ1 and type2 in both server and in parallel? field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the duplicate rows,inthe fields?
How a routine is called in datastage job?
Explain datastage architecture?
how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.
What is the purpose of pivot stage and types of containers in datastage
Define Data Stage?
Name the command line functions to import and export the DS jobs?
How a source file is populated?
Have you have ever worked in unix environment and why it is useful in datastage?
What are data elements?
Differentiate between odbc and drs stage?
client know skid info?
Does datastage support slowly changing dimensions ?