Answer / fayaz

by using copyfile we can easily create 4 columns in targetfile.

What is the difference between validated and compiled in the datastage?

0 Answers  

---

Hi guys, please design a job with derivation(solution). write exact conditions. My requirement Source table emp_no qualification 1 a 1 c 2 a 3 c 3 b Target table emp_no qualification 1 b 2 b 2 c 3 a Here every employer have three qualifications i.e a,b and c. what ever source table dont have some qualification, that will be move to target table. Like above. Hope u get the point. Thanks.

4 Answers   UHG,

---

Can aggregator and transformer stages use to sort the data? How ?

2 Answers  

---

A flatfile contains 200 records.I want to load first 50 records at first time running the job,second 50 records at second time running and so on,how u can develop the job?pls give the steps?

3 Answers   TCS,

---

IS IT POSSIBLE TO USE DATASET AS A SOURCE FILE?

3 Answers   Infosys,

---

How many input links can you give to a Transformer stage?

6 Answers  

---

why do we need a datawarehouse when we have databases to store data?

1 Answers   L&T,

---

How to convert alpha Numeric values to alpha using functions?

1 Answers   CTS,

---

Can we use sequential file as source to hash file? Have you do it ?if what error it will give?

1 Answers   SS Solutions,

---

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

0 Answers   Syntel,

---

What are the environmental settings for data stage,while working on parellel jobs?

2 Answers   Satyam,

---

Source have 1000 records and it can have three nodes ok but i want how many records are executed on each node?

3 Answers   TCS,

---