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.

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.

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

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.

What are the processing stages?

0 Answers  

---

I have a few records just I want to store data in to targets cycling way how?

0 Answers   Polaris,

---

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?

1 Answers   IBM,

---

what is hash file

2 Answers   CTS, IBM,

---

IS FILE SET CAN SUPPORT I/P AND O/P LINK AT A TIME?

1 Answers  

---

What is difference between join, merge and lookup stage?

0 Answers  

---

What are the different layers in the information server architecture?

0 Answers  

---

How many jobs in ur project? Explain any complex job u have done in ur project?

1 Answers   IBM, TCS,

---

where we use config file as parameter ?

1 Answers   IBM,

---

how to find no.of records in sequntial file itself?

4 Answers  

---

which unix commands mostly used in datastage

3 Answers   HSBC,

---

What steps should be taken to improve Datastage jobs?

0 Answers  

---