If seg file having 10 records
ex:eid
1
2
"
"
10
if oracle database having 100 records
ex:eid
1
2
"
"
100
how to delete matched records permenently from oracle
database using datastage ?
- 5 Answers
- 9168 Views
- Infotech, I also Faced
- E-Mail Answers
Answer Posted / shar
Vaibhav can u plz explain how an sql query is written b/t
seq file and oralce table in oracle stage delete query?
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)
Is the value of staging variable stored temporarily or permanently?
On which interface you will be working as a developer?
What are stage variables, derivations and constants?
How to implement complex jobs in data stage?
State the difference between an operational datastage and a data warehouse?
What is datastage engine?
What is data partitioning?
1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?
What all are the different way to run a job?
What are stage variables?
What is the flow of loading data into fact & dimensional tables?
What is the process of killing a job in datastage?
Which commands are used to import and export the datastage jobs?
EXPLAIN SCD
