Answer / mallika

Sequential file stage doesn't recognize nulls. So in format
tab you will find an option null to value property and there
you can enter any value

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 explain wt is the pool for file.

1 Answers   CTS,

---

1.what is stagearea?what is stage variable? 2.this is my source source:id, name target:id, name 100, murty 100,madan we have three duplicate records for the id column,how can we getthe source record? 100,madan 100,saran

1 Answers   HCL,

---

which unix commands mostly used in datastage

3 Answers   HSBC,

---

How to initialize environment variables?

4 Answers   Infosys,

---

What is container and then types?

1 Answers  

---

WHAT ARE THE STAGES U WILL USE IN IMPLEMENTING SCD2/DATE FIELD

8 Answers   L&T,

---

What is the difference between odbc and drs stage?

0 Answers  

---

1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?

0 Answers   Wipro,

---

how to remove duplicates in transformer stage by using stage variables?one example?

6 Answers   Syntel, TCS,

---

What is the Difference between Change capture stage and Difference Stage ? What are its significance individually ?

1 Answers  

---

Name the different sorting methods in datastage.

0 Answers  

---