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 can we do with datastage director?
sed,awk,head
Can you filter data in hashed file?
What is a datastage job?
What are the types of hashed files in data stage
Can you highlight the main features of ibm infosphere information server?
What is meta stage?
What is usage analysis in datastage?
What is staging variable?
Describe routines in datastage? Enlist various types of routines.
Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?
how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.
What all the types of jobs you developed?
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
Explain how a source file is populated?
