Interested to Buy Any Domain ? << Click Here >> for more details...
how can we join one oracle & flat files ?
- 2 Answers
- 9567 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 you can fix the truncated data error in datastage?
file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4
Lookup constraints
Which type of joins Merge stage can support?
What is a quality stage?
what is factless fact table?
what is mapping lookup
How to initialize environment variables?
Different ways a project can be moved to production ?...example ….export-import and Version control.
Tell me the syntax of Configuration file?
What is apt_config in datastage?
Name the different sorting methods in datastage.
Teradata 
