Answer / sarath

We can not say this is/isnt a migration project based on your query.For many projects we get the data from mainframe or as flat file
Migration project means the entire code is developed in one technology ( lets say eg: SAS) and now they want to implement the same code in new technology ( say now DATASTAGE) for better performance. as it will take more time to complete the job in SAS compared to datastage. finally the goal is optimization.

What is a range lookup?

2 Answers   IBM,

---

Explain Quality stage?

0 Answers  

---

1.What is the flow of Transformer? 2.How can you do INDEX table in DataStage level?

0 Answers   EDS,

---

if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables? how can i implement scd typ1 and type2 in both server and in parallel? field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the duplicate rows,inthe fields?

0 Answers   IBM,

---

SEQUENTIAL FILE I HAVE ONE RECORD,I WANT 100 RECORDS IN TARGET?HOW CAN WE DO THAT?PLS EXPLAIN ME AND WHAT STAGES ARE THERE?WHAT LOGIC?

1 Answers   TCS,

---

---

What a datastage macro?

0 Answers  

---

I am defining one varaible parameter date in job parameters.I want use this variable date in where clause in source query.

2 Answers   TCS,

---

if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?

1 Answers   IBM,

---

I have 100 records how can I load at a time from the single time

1 Answers  

---

how can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction

1 Answers   Reliance,

---

How can we read latest records in a text file named file1.txt using seq file stage only? file1 having 100 records in that 5 record sare latest records.How can we read that latest records?

3 Answers   Caterpillar,

---

How do y read Sequential file from job control?

2 Answers   HP, IBM, Telesis,

---