Answer Posted / pavan

To remove duplicates we could use Remove Duplicates Stage.
If the requirement states not to use a remove duplicates
stage, u culd use Sort stage, by setting one of its
property Allow Duplicates to false.

What is the differentiate between data file and descriptor file?

1304

---

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?

2131

---

What is the roundrobin collector?

1038

---

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 ?

1963

---

What are the various kinds of the hash file?

1095

---

what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?

1331

---

table actions available in oracle connector?

1554

---

How do you run datastage job from the command line?

1027

---

Nls stands for what in datastage?

1142

---

Why do we use link partitioner and link collector in datastage?

1076

---

How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.

3415

---

Explain datastage architecture?

1333

---

What is ibm datastage flow designer?

1080

---

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 difference between informatica and datastage?

1146

---