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

Give an idea of system variables.

1023

---

Differentiate between odbc and drs stage?

1049

---

how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)

917

---

How do you run datastage job from the command line?

1082

---

How a source file is populated?

1063

---

What are the functionalities of link collector?

1085

---

What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)

2382

---

A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?

2503

---

What is a quality stage in datastage tool?

1071

---

What a datastage macro?

1056

---

What is the difference between hashfile and sequential file?

1257

---

What are the different type of jobs in datastage?

1042

---

Differentiate between datastage and informatica?

1180

---

Differentiate between datastage and datastage tx?

1048

---

what are .ctl(control files) files ? how the dataset stage have better performance by this files?

2811

---