Answer Posted / linda

Backfill

Explain the importance of surrogate key in data warehousing?

1190

---

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?

2179

---

How rejected rows are managed in datastage?

1520

---

What is meta stage?

1179

---

What are the features of datastage flow designer?

1039

---

What is merge stage?

1310

---

how to export or import the jobs in .ISX file

1203

---

Differentiate between data file and descriptor file?

1056

---

What are the stages in datastage?

1083

---

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

3755

---

What is the precedence of stage variables,derivations, and constraints?

1086

---

how can we create rank using datastage?what is the meaning of rank?

8792

---

Differentiate between validated and Compiled in the Datastage?

1278

---

What are constraints and derivations?

1168

---

Lookup constraints

1254

---