Answer / pakkya

implement scd type1 -
simply overwrite with new data
implement scd type2 -
use merge stage to do an inner join on all columns after
sorting data, rows that do not join from merge result are
your changes
remove ',' - use Trim function with A option that removes
all occurences of ','

Answer / murari

By using the sort stage we can remove the duplicates by setting the option ALLOW DUPLICATES=FALSE......

Suppose take my name "Reddyvaraprasad" From source it is coming Reddy vara prasad Need to get As Reddyvara prasad/

4 Answers   TCS,

---

What is the difference between passive stage and active stage?

0 Answers  

---

in sequtial file 2 columns avaliable, i want only one column load the target. for this we can do by modify and copy stage. But here when using modify stage (in property drop column1) until it is ok. if target is data set How to view the data. with out using data management. what is the reason for this. if any body know this answer plz tel me. thanks.

1 Answers   IBM,

---

which is the most complex job in your career? Please tell me answer?

2 Answers   IBM, Wipro,

---

How you Remove the Dataset in Unix?

5 Answers  

---

when U have a remove dublicate option in sort stage, why we have a remove dublicate stage in PX, thought it is recamended to sort data before using a remove dublicate stage. I hae been thinking this from days....

4 Answers   Target,

---

why dataset ?

2 Answers  

---

my soure table is emp having columns sal,deptno in the deptno 10,20,30deptno row are there expected out put is min(sal) of 10th deptno,max(sal) of 20th deptno,mean(sal) of 30th deptno using aggregation stage

4 Answers  

---

how to sort two columns in single job in datastage.

0 Answers   TCS,

---

what is time dimension? and how to populate time demension

2 Answers   TCS,

---

What could be a data source system?

0 Answers  

---

what is combinability and non combinability?

2 Answers  

---