Answer / sri

Using the Pivot we can convert the columns into rows

Answer / manu

By using 'ETERNAL PIVOT STAGE' we can do this

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,

---

how to find out number of records imported into source file?

1 Answers  

---

What is the differentiate between data file and descriptor file?

0 Answers  

---

Can you explain how could anyone drop the index before loading the data in target in datastage?

0 Answers  

---

what is the use of DSattchJob?DetachJob? where can we find it?

0 Answers   IBM,

---

---

Explain entity, attribute and relationship in datastage?

0 Answers  

---

what is a force compile

2 Answers   Cap Gemini, IBM,

---

how to change left and right links in join stage?

4 Answers   Cap Gemini, IBM,

---

Which type of joins Merge stage can support?

7 Answers   IBM,

---

Hi guys, Design job sequence, we have 3 sources, in that 1st source in abort then only run the remaining sources.. How please design the job. Thanks.

2 Answers   IBM,

---

What are the benefits of datastage?

0 Answers  

---

What are sequencers?

0 Answers  

---