How do you find the number of rows in a sequential file?

1 Answers  

---

which unix commands mostly used in datastage

3 Answers   HSBC,

---

If you want to use the same piece of code in different jobs, how will you achieve it?

0 Answers  

---

eno ename 1 qaz 1 wsx 1 edc 2 zxc 2 asd 3 qwe 3 wer 3 tru 4 rgj Output: eno ename count 1 qaz,wsx,edc 3 2 zxc,asd 2 3 qwe,wer,tru 3 4 rgj 1 I want the above output to be solved by DataStage as well and I have to write SQL query for the same output.

4 Answers   Wipro,

---

how CAN we remove duplicates in dataset?

2 Answers   IBM,

---

i have 3 diffrent tables. 1) US rate data 2)CANADA rate data and 3)MEXICO rate data. All 3 tables have 6 collumns each. 4 collumns are commun to all tables and 2 are diffrent. Now at target i want single table say Country rate which will have (4+2+2+2+1 flag) 11 collumns. I will add a flag collumn which will indicate country and will put nullable collumns which are not common to other. How i can implement this in datastage?

1 Answers   ABC,

---

What all the types of jobs you developed?

0 Answers  

---

what is the main difference between sorragate key n primary key in one word

2 Answers  

---

what is ds administrator used for?

0 Answers  

---

What is Fastly Changing Dimension?

6 Answers   TCS,

---

In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?

0 Answers  

---

What is data partitioning?

0 Answers  

---