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 perform incremental load in datastage?

0 Answers  

I have scenario like this seq file --> transformer --> sort stage --> dataset In this job which prtitioning technique you are using and why???

3 Answers   CTS, IBM,

What is the Difference Between DataStage 7.5 version and 8.1 Version?

10 Answers   IBM,

Can you explain kafka connector?

0 Answers  

What is the difference between an operational datastage and a data warehouse?

0 Answers  

How do you start developing a datastage project?

0 Answers  

how do you pass parameters in a script?

1 Answers   L&T,

Hi am sundar, i have datas like 00023-1010 00086-1010 00184F2-1010 . . . . SCH-AS-1010 200-0196-039 . . . Now i want the result "SCH-AS" in onee column and "1010" in another column.. Can any one tell the answer...

5 Answers  

what is the difference between == and eq in UNIX shell scripting?

0 Answers   CTS,

wt is the difference between swith and filter stage

6 Answers   IBM,

AGGREGATOR default datatype

0 Answers   CTS,

where we use config file as parameter ?

1 Answers   IBM,

For more Data Stage Interview Questions Click Here
Categories