how can we join one oracle & flat files ?
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 |
WHERE YOU USE UNIX COMMANDS AS A ETL DEVELOPER?
what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?
If there is a file that contains 1000 records, I need the ouput to contain these 1000 records with the header as file name concatenated with the current timestamp and trailer as the count of records
if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?
how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara
im new to this tool im now at project plz tell me step by step process how to design plz help me i wnt to go with exp for job plz give me d proper design and explination
How to convert RGB Value to Hexadecimal values in datastage?
What is the difference between an operational datastage and a data warehouse?
how to create document in datastage?
How to enter a log in auditing table whenever a job get finished?
source has 2 fields like COMPANY LOCATION IBM HYD TCS BAN IBM CHE HCL HYD TCS CHE IBM BAN HCL BAN HCL CHE LIKE THIS....... AND I WILL GET THE OUTPUT LIKE THIS.... Company loc count TCS HYD 3 BAN CHE IBM HYD 3 BAN CHE HCL HYD 3 BAN CHE PLZ SEND ME ANSWER FOR THIS QUESTION..........
What is configuration your file structure 2)I have two databases both are Oracle while loading data from source to target the job takes 30 min but I want to load less time how?