Interested to Buy Any Domain ? << Click Here >> for more details...
how can we join one oracle & flat files ?
- 2 Answers
- 9659 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 |
In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?
Hi friends If anybody completed datastage 8.5 certification.Could please guide me what are the topics new in 8.5 certification.
what is the difference between == and eq in UNIX shell scripting?
What is difference between symmetric multiprocessing and massive parallel processing?
hi, 1)totally how many jobs created in ur project 2)what is ur datamart size & Dwh size 3)How secure ur project 4)could u plz tell be about testing process after complete the job will run sucessfully or not in Datastage
Explain ibm infosphere information server and highlight its main features?
how to get the unique records on multiple columns by using sequential file stage only
What are datastage sequences?
i 10 jobs first two jobs are runing in 2nodes,next 2 jobs are running in 4 nodes, next 4 jobs are running in 6 nodes and the remaining jobs are running on 10 nodes. how to change the node configuration?
can a fact table contains textual information
6 Answers HCL, HCL BSERV, IBM,
You enter values in a schema file for RCP and you also entered values in sequential file? which one will it take?
Hi dude, i/p eno ename date edate deptno 1 x 10thjuly 30july A 2 y 10th aug 30 aug B 1 x 1aug ------ A 3 z 1jan ------ c 2 y 1sep ------ B o/p is eno ename date edate deptno 1 x 1aug ------ A 2 y 1sep ------ B 3 z 1jan ------ c Here edate is System generates we don't know that value. Please design the job by using SCD stage and Sql query. If any body know this answer please tel me. Tanks.
Teradata 
