Answer Posted / kiransitams

any number of columns

What is aggtorec restructure operator?

1427

---

Explain ibm infosphere information server and highlight its main features?

1081

---

What is job control?

1098

---

Explain datastage architecture?

1384

---

What is ibm datastage flow designer?

1128

---

how to implement scd2 in datastage 7.5 with lookup stage

5593

---

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?

2167

---

i WANTED TO USE THE RANGE LOOKUP SCENARIO IN DATASTAGE 7.5.2 SRVER JOB.i HAVE A DATE FIELD IN SOURCE AND I SHOULD MATCH IT WITH A FIELD IN LOOKUP FILE.BUT,THE FIELDS SHOULD MATCH EVEN THOUGH THERE IS SOME RANGE.CAN SOMEONE TELL ME HOW CAN I DO THAT. THANKS

3740

---

Why do you need stage variables?

1170

---

how to delete one row in target dataset

3101

---

How do you generate sequence number in datastage?

1072

---

What are the some differences between 7.x and 8.x version of datastage?

1246

---

im new to this tool im now at project plz tell me step by step process how to design plz help me i wnt to go with exp for job plz give me d proper design and explination

2157

---

i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu

2711

---

How to perform incremental load in datastage?

1181

---