tab1 tab2 1,a 1,d 2,b 3,c perfoms outerjoin what is the o/p? write sql query for outerjoin?

3 Answers   Infotech,

---

what is the diff b/w switch and filter stage in datastage

2 Answers   Cap Gemini,

---

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,

---

while we using change capture stage we have to be take two table thats are 1.before table 2. after table . what is before table and after table please give me clear notation Thank You very much in advance

2 Answers   MGL,

---

1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do

0 Answers   IBM,

---

1)How to Duplicate Records Delete in Sequential file?

4 Answers   IBM, TCS,

---

Can you explain how could anyone drop the index before loading the data in target in datastage?

0 Answers  

---

Difference between server jobs & parallel jobs?

0 Answers  

---

What are the environmental settings for data stage,while working on parellel jobs?

2 Answers   Satyam,

---

What are the stages in datastage?

0 Answers  

---

what is sparse lookup?

7 Answers   IBM,

---

hi All, i have one scenario like if source--->transformer-->2 target sequential files the 1 st target sequential file is loads the data from source and 2nd target sequntial file contain the 1st target total record count,and file name of 1 st target seq file and timestamp seperated by delimeter for example if source have 10 record the 1st target seq file hav 10 records and 2nd target seq file example 10|xyz.txt|20101110 00:00:00 could you please help me out how can i implement in datastage job.

4 Answers   IBM,

---