how can we join one oracle & flat files ?
- 2 Answers
- 8344 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 |
State the difference between an operational datastage and a data warehouse?
diff between changecapture & diffrence stage which situvation we can use the diffrence stage ?
1. How many People are part of your Team? 2. Explain how you create jobs or flow of project? 3. Join Stage vs Lookup vs Merge Stage 4. Summation scenario based question - How you find sum of salary for a specific employee (Explain stages and flow of job)? 5. Explain Remove duplicates stage ? Can you do sort in this stage? 6. SQL Questions - Joins - Types, Difference between Join and Union 7. Unix Questions - How you run the Job, How you list all jobs in project 8. Explain Environmental Variables? 9. SQL Scenario - If you have 3 Identical record in a Table, Ex: 1, Ram, Xyz; 1, Ram, Xyz; 1, Ram, Xyz; Delete only 2 of the records and keep only 1 using the Delete query. How you will you do this?
what is the differeces between hash and modulus partition methods
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,
hi iam new to this tooliam cmpltied to know abt datastage so now iam in project tell me whole step by step what iam doing iwnt to go with exp so plz hlp me pals
How a routine is called in datastage job?
Tell me Wt main advantage of Stage varibles? Project level hints?
How you can fix the truncated data error in datastage?
What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?
What is RCP?
Which type of joins Merge stage can support?
Teradata 
