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

1 Answers  

---

1. How many People are part of your Team? 2. Explain how you create jobs or flow of project? 3. Join Stage vs Lookup vs Merge Stage 4. Summation scenario based question - How you find sum of salary for a specific employee (Explain stages and flow of job)? 5. Explain Remove duplicates stage ? Can you do sort in this stage? 6. SQL Questions - Joins - Types, Difference between Join and Union 7. Unix Questions - How you run the Job, How you list all jobs in project 8. Explain Environmental Variables? 9. SQL Scenario - If you have 3 Identical record in a Table, Ex: 1, Ram, Xyz; 1, Ram, Xyz; 1, Ram, Xyz; Delete only 2 of the records and keep only 1 using the Delete query. How you will you do this?

1 Answers  

---

explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?

0 Answers   CGI,

---

1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?

0 Answers   IBM,

---

How to lode data in sequntional files perform faster?

1 Answers   Polaris,

---

how to handle null values in sequential file?

1 Answers   HCL,

---

What is ibm datastage?

0 Answers  

---

How can u execute the sql query through unix? What is the Primary key for Dimension table? what is the primary key for Fact table?

5 Answers   TCS,

---

in oracle target stage when we use load option and when we use upsert option?

0 Answers  

---

how to cleansing data

6 Answers   Cap Gemini,

---

How a routine is called in datastage job?

0 Answers  

---

How do u view log file for a particular job?

6 Answers   HP,

---