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.

Hi frnds, my scenario is like i'm having a record 1234"1323£3434%343434^23232!1212$23232 in the above record all the special characters must be removed.how can we do it in datastage 8.0.1.can any one please ans this? thanx in advance

2 Answers   IBM,

---

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

1 Answers   Polaris,

---

what is diff b/w datastage 8.1,8.5,8.7?

1 Answers   IBM,

---

What is datastage engine?

0 Answers  

---

disign the complex job in u r project?(they are aksing only complex job design and then data flow...)

0 Answers  

---

I have a input as: Col 1 1 2 2 3 I want 3 output as: Output1: 1 1 Output2: 2 2 Output3: 3 i.e. same duplicates should be in one target, other duplicate values should be in another target and so on.. Pls help

9 Answers   IBM,

---

I have a few records just I want to store each records tow times in target how?

2 Answers   Polaris,

---

How many input links can you give to a Transformer stage?

6 Answers  

---

what is the difference between the active datawarehouse and datawarehouse

1 Answers   TCS,

---

INPUT file 'A' contains: 1 2 3 4 5 6 7 8 9 10 input file 'B' contains: 6 7 8 9 10 11 12 13 14 15 Output file 'X' contains: 1 2 3 4 5 Output file 'Y' contains: 6 7 8 9 10 Output file 'Z' contains: 11 12 13 14 15 How can we implement this in a single ds job?

11 Answers   CTS,

---

project Steps,hits, Project level HArd things,Solved methods?

0 Answers   Hexaware,

---

wt is the difference between swith and filter stage

6 Answers   IBM,

---