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.

How to read multiple files at different directories using a single Sequential File stage in DS Enterprise Edition

6 Answers   TCS,

---

hi i am madan, in real time data stage who is the source provide? and how to recevied in developer? Pls send me answer 

1 Answers   HCL,

---

what is mapping lookup

1 Answers  

---

at source level i have 40 columns,i want only 20 cols at target what r the various ways to get it

5 Answers   IBM,

---

Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2

0 Answers  

---

Unix Qn asked in datastage interview: I have diff type(.txt, .tmp, .bat etc) of file in 4 diff directories, I want move all '.txt' file from 4 directories to other folder. And need to delete all the files except which are created TODAY?

2 Answers   TCS,

---

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

0 Answers   CTS,

---

Hi, I have 3 records, 1 Srini 1 vasa 2 reddy now i want o/p like this 1 Srinivasa 2 reddy could u please help in this Thanks in advance.

6 Answers   Teradata,

---

What are the functionalities of link partitioner and link collector?

0 Answers  

---

How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?

0 Answers   Reliance,

---

cust id,cust quty like 1,101;1,102;1,103 i want output like cust id,cust quty 1 101,102,103 in oracle please write a query in oracle

3 Answers   TCS,

---

whats relation between configuration file and datasets?

2 Answers   L&T, Wipro,

---