Answer / chethankumar km

using Pivot stage
seq--->pivot--->dataset
in pivot output col name one same as city second one as
company in that col in derivation name1,name2,name3,name4.
compile and run will get desired output.

1) In a dataset how to delete a single row? 2) i have 50 rows , i want to display 5-7 records only? How to write the sql query? 3)i have 40 rows,i want to display last row? write sql query?

7 Answers   Wipro,

---

explain about citrix scheduling tool in datastage

0 Answers   HSBC,

---

how to find diff between 2 dates without using Icon... funtions?

1 Answers  

---

in job of 30 one job is very slow due to this entire job is very slow how can u know which job is slow?

0 Answers   IBM,

---

how many write modes are there in ds

2 Answers   IBM,

---

How many types of views are there in a datastage director?

0 Answers  

---

what is main difference between change capture and change apply stages

4 Answers   IBM,

---

What are the steps needed to create a simple basic datastage job?

0 Answers  

---

What are the components of ascential data stage?

0 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  

---

what is hash file

2 Answers   CTS, IBM,

---

What is the difference between odbc and drs stage?

0 Answers  

---