3) Sequential file contains data like Empno ename sal 111 abc 2000 Trgt file: Trgt1----111 Trgt2----abc Trgt3---2000

2 Answers  

---

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,

---

In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?

0 Answers  

---

Is the value of staging variable stored temporarily or permanently?

0 Answers  

---

Define project in datastage?

0 Answers  

---

What are the types of hashed files in data stage

0 Answers  

---

What are the unit test cases you used in your project?

1 Answers   CSC, HY,

---

what is hash file

2 Answers   CTS, IBM,

---

Define data aggregation?

0 Answers  

---

How to find value from a column in a dataset?

0 Answers   TIAA CREF,

---

What is the flow of loading data into fact & dimensional tables?

0 Answers  

---

create a job to get the previous row salary for the current row.if there is no previous row exists for the current row,then the previous row salary should be displayed as null? empid   salary   previoussalary 10      1000     null 20      2000     1000 30      3000     2000       40      4000     3000

5 Answers   Genpact,

---