How can you join flat file, oracle as a sources?
Answer Posted / vijay
First you convert the data from flat file into oracle , so
now we have two oracle db's then easily we can join these
two sources using join stage.
I have also faced this question at IBM US.
| Is This Answer Correct ? | 6 Yes | 4 No |
Post New Answer View All Answers
Differentiate between validated and Compiled in the Datastage?
What are the types of jobs we have in datastage?
What is the difference between datastage and informatica?
Differentiate between data file and descriptor file?
How rejected rows are managed in datastage?
Name the command line functions to import and export the DS jobs?
Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC
describe the Steps to confiure a Qlogic switch
What is oci?
What is merge stage?
I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this
Have you used Unstructured data?
Define oconv () and iconv () functions in datastage?
What is a merge?
What are the different common services in datastage?