Interested to Buy Any Domain ? << Click Here >> for more details...
how can we join one oracle & flat files ?
- 2 Answers
- 9503 Views
- ME, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / amit trivedi
We need to use external tables to join a flat file and oracle table.
First insert all records of flat file into an external table and then join these two tables.
else, use next step, insert data from external table to oracle table and join these two tables using join conditions.
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / lokesh
first we need to converted flat files in tables ofter join
the oracle and that table
| Is This Answer Correct ? | 0 Yes | 2 No |
How do you register plug-ins?
what is the use of surogate key in datastage
Differentiate between datastage and informatica?
Can you explain engine tier in information server?
What is a ds designer?
parallel jobs run on cluster machines. server jobs run on smp and mpp. What do mean by cluster mechines and SMP and MPP..?
Explain how a source file is populated?
what is .dsx files
How to write a expression to display the first letter in Caps in each word using transformer stage ? Please let me know ASAP Thanks in advance...
0 Answers Alpharithm Technologies,
Why we need datasets ratherthan sequential files?
How do you get log info into a file?
hi, how would i run job1 then job 3 , then job2 in a sequence of job1 ,job2,job3. Thanks sunitha
Teradata 
