Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / 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 |
Post New Answer View All Answers
What are the primary usages of datastage tool?
Highlight the main features of datastage?
Terminate Activity
whom do you report?
What is the command line function to import and export the ds jobs?
How to read multiple files using a single datastage job if files have the same metadata?
how to add a new records into source?
Hi guys, Please design a job for dis requirement with derivation(solution). my source table like dis. emp_no qualification 1 a 1 c 2 a 3 c 3 b To loaded to target like dis emp_no qualification 1 b 2 b 2 c 3 a my requirement is every employer have three qualifications i.e a,b and c. what qualification missed in source table that will be move to target systems. Hope u got it the requirement. Right Thanks.
What is use Array size in datastage
in oracle target stage when we use load option and when we use upsert option?
How you Implemented SCD Type 1 & Type 2 in your project?
What is difference between symmetric multiprocessing and massive parallel processing?
DB2 connector> transformer > sequential file Data will be exported into a csv format in a sequential file. This file will be send in a email using a sequence job. Problem here is, how to avoid sending a blank csv file? When I ran the job there are chances that it might return zero records but in the sequence job csv file is going blank. how can I avoid this? thanks
Define APT_CONFIG in Datastage?
How to find value from a column in a dataset?
