Answer / metilda

We cannot see the data in the Data Set (.ds files) through
Unix, Editplus etc. But we can view the data by connecting
a Peek stage to the Data Set stage in a job. Go to Director-
-> job name ---> Peek stage (view .ds file data)

Answer / balaji

right click on the data set and select by view data option

Hi, Please tell me how to solve this scenario in datastage ? Here we have 3 columns in a table TEST CODE,ENTRY DATE and BATCH The table looks like CODE ENTRYDATE BATCH 100 100716 1 100 100716 1 100 100716 1 200 122517 2 200 122517 2 302 555555 8 302 555555 8 302 555555 8 We need to create a seqno on grouping these 3 columns. The result should be like this. CODE ENTRYDATE BATCH SEQNO 100 100716 1 1 100 100716 1 2 100 100716 1 3 200 122517 2 1 200 122517 2 2 302 555555 8 1 302 555555 8 2 302 555555 8 3

1 Answers   Alpharithm Technologies,

---

what is stage is used for below Input columns: dept|mgr|employee|salary Output columns: mgr|count of employee per mgr|avg salary per dept note: each dept has one mgr and each mgr has many employees

0 Answers  

---

how to closeing records after 10,000 records come?

3 Answers  

---

what is materialized view used datastage?

1 Answers   HSBC,

---

Thanks to all people who are posting their comments...

1 Answers   CTS,

---

I have 5 different sources i want same records in 5 different targets Can you any body send me this question answer rathdsetl@gmail.com

2 Answers   TCS,

---

How to remove duplicates in transformer stage? in parallel mode

6 Answers   Syntel, TCS,

---

what are the different type of errors in datastage?

2 Answers   Wipro,

---

i have flat file and using unix how can i generate sequence number into targer?

1 Answers   Cap Gemini,

---

How to generate surrogate key without using surrogate key stage?

6 Answers   IBM,

---

Why we use parameters instead of hard code in datastage.

2 Answers   IBM,

---

What is container and then types?

1 Answers  

---