Interested to Buy Any Domain ? << Click Here >> for more details...
how can we join one oracle & flat files ?
- 2 Answers
- 9552 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 |
diff between changecapture & diffrence stage which situvation we can use the diffrence stage ?
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?
what is the Difference Between Datastage Server Edition and Parallel Edition?
How to use Environment variable's in datastage?(use of process)
how to validate the jobs
How can we improve the performance in datastage?
In my project source data comes from MAINFRAME in files.so,This time data is coming as a binary file...I know for binary data we use Complex flat file stage..I have used it also..but on 'view data' data is not coming correctly..as it in MAINFRAME.give me some ideas..
In my source i have 10 records but i want 11 records in target. How can i acheive this in Server jobs.
if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?
Hi friends If anybody completed datastage 8.5 certification.Could please guide me what are the topics new in 8.5 certification.
How do you load dimension data and fact data? Which is first
Anyone has Datastage certification free dumps for 000-418 , 000-421 codes, mail me @ manik.dwh@gmail.com 000-418 : InfoSphere DataStage v8.0 000-421 : InfoSphere DataStage v8.5
Teradata 
