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
What is the roundrobin collector?
What are the functionalities of link partitioner?
What is the method of removing duplicates, without the remove duplicate stage?
Differentiate between validated and Compiled in the Datastage?
What is a ds designer?
How you Implemented SCD Type 1 & Type 2 in your project?
What is the importance of the exception activity in datastage?
How to find value from a column in a dataset?
How rejected rows are managed in datastage?
What steps should be taken to improve Datastage jobs?
Enlist various types of routines in datastage.
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
What is the project in datastage?
What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)
how can we create rank using datastage?what is the meaning of rank?