Answer / datastage4you

Use Pivot stage

Thanks
www.datagenx.net

How to read multiple files at different directories using a single Sequential File stage in DS Enterprise Edition

6 Answers   TCS,

---

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  

---

Which algorithm you used for your hashfile?

0 Answers  

---

What is the difference between SQl Loader and OCI in datastage?

2 Answers   CSC,

---

cust id,cust quty like 1,101;1,102;1,103 i want output like cust id,cust quty 1 101,102,103 in oracle please write a query in oracle

3 Answers   TCS,

---

on how many columns we can perform aggregation in the Aggregator stage?

3 Answers   Reliance,

---

How to write a left outer join condition by using Transformer stage in server jobs? Could any one help me?

1 Answers  

---

detail about sdlc

4 Answers  

---

Where the datastage stored his repository?

0 Answers  

---

hi everbody, i have a problem in my project.. Native Error Code: -407 "Assignment of a null value to a not null column"  hi everbody, i have a problem in my project.. Native Error Code: -407 "Assignment of a null value to a not null column" i have no idea, what should i do..please help :(

3 Answers  

---

how can we create tables in datastage?

1 Answers  

---

How to lode data in sequntional files perform faster?

1 Answers   Polaris,

---