Answer Posted / shailesh

simplest solution that i can think of using ds8.1 pivot satge
seqfile--->pivot--->target

in pivot stage give the derivation for new_col as old_col,old_col,old_col,old_col,old_col (five times)
map it to target you will get the desired output

Can you implement SCD2 using join, transformer and funnel stage?

1501

---

How rejected rows are managed in datastage?

1449

---

What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)

2330

---

Differentiate between validated and Compiled in the Datastage?

1196

---

Explain the situation where you have applied SCD in your project?

1976

---

Why we use surrogate key?

1159

---

What is the difference between the local container and shared container?

1043

---

What are some different alternative commands associated with "dsjob"?

1082

---

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 ?

1967

---

What is orabulk stage?

992

---

What is the difference between odbc and drs stage?

1044

---

what are .ctl(control files) files ? how the dataset stage have better performance by this files?

2760

---

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

2676

---

What is the use of hoursfromtime() function in transformer stage in datastage?

1001

---

What are the different type of jobs in datastage?

1002

---