Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Data Warehouse >> Data Stage
  2. Suggest New Category

How can you join flat file, oracle as a sources?

Question Posted / vijay

Answers were Sorted based on User's Feedback



How can you join flat file, oracle as a sources?..

Answer / kalyanreddy

Hi Vijay,


first populate flatfile data to orale db

two methods,

1. write a join query in source oralce stage and link to
target.

2. take two oracle sources like s1 and s2 , use join stage
and link to target

or
direct method

3.take flat file and oracle source, use join stage and link
to target.

Is This Answer Correct ?    5 Yes 1 No

How can you join flat file, oracle as a sources?..

Answer / 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

How can you join flat file, oracle as a sources?..

Answer / kiran

hai vijay..,

See Whats the Question and please first clear ur
questions.then give proper answer boss.by using flat files
also u can join and populated to target.please clear ur
quetion.

Thanks & Regards
Kiran
09393363309

Is This Answer Correct ?    2 Yes 1 No

How can you join flat file, oracle as a sources?..

Answer / bharathd

By using Seqfile stage(flat file) and Oracle(Dynamic RDBMS
stage)to extract the data from sources, the join the data
using join stage.

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Data Stage Interview Questions

how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?

0 Answers   HCL,

Explain the datastage parallel extender (px) or enterprise edition (ee)?

0 Answers  

Triggers,VIEW,Procedures

0 Answers   CTS,

If seg file having 10 records ex:eid 1 2 " " 10 if oracle database having 100 records ex:eid 1 2 " " 100 how to delete matched records permenently from oracle database using datastage ?

5 Answers   Infotech,

what is a force compile

2 Answers   Cap Gemini, IBM,

explain how to create SCD-2 IN DATASTAGE 7.5X2 PLZ EXPLAIN WITH 4 OR 5 RECORDS TAKE IT EXAMPLE AND JOB DESINGN URGENT

3 Answers   IBM, Polaris,

Give an idea of system variables.

0 Answers  

What are the third party tools you used in your project?

1 Answers   IBM,

What is the surrogate key? what is the use of surrogate key? how to Create surrogate key Generator in scd2 in 8.5?

5 Answers   SLK Software,

I have oracle enterpaise stage, oracle bulkloader stage, ODBC stage and I want to load data in to target, which of the above stages do I need to use and why?

3 Answers   Virtusa,

What is the use of datastage designer?

0 Answers  

How to find value from a column in a dataset?

0 Answers   TIAA CREF,

For more Data Stage Interview Questions Click Here
Categories