Answer / vinoth

Can you please more specific in your question?

What will be the source ?

Answer / datastage4you

Go to column tab - Load - select metadata file


Thanks
www.datagenx.net

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,

---

can a fact table contains textual information

6 Answers   HCL, HCL BSERV, IBM,

---

How do you get log info into a file?

1 Answers  

---

State the difference between an operational datastage and a data warehouse?

0 Answers  

---

how many rows sorted in sort stage by default in server jobs

0 Answers   Syntel,

---

In merge stage can we update the values?

3 Answers   TCS,

---

wt is the difference between swith and filter stage

6 Answers   IBM,

---

Does datastage support slowly changing dimensions ?

0 Answers  

---

what is meta data? Explain? Where it is used?

9 Answers  

---

when will you go for dataset and fileset?

2 Answers   Accenture,

---

how to run a sequential file stage in parallel if the stage is used on the TARGET side

0 Answers   Virtusa,

---

1.which index is follows the dimensions tables?why? 2.what is the use of trigger in job sequence? 3.what is the mean of optimization? 4.what is the job control?when we use it? what is difference bet batch and sequencer? 6.seq--->seq,seq--->copy--->seq which one is best and efficient?

1 Answers  

---