Answer Posted / san

When ever you want join the two files .. you need to do hash
partition using natural keys both sides. Otherwise the value
related keys will go into different partitions and while
join match will not occur properly.

What are the types of views in datastage director?

1776

---

Describe stream connector?

1311

---

Explain entity, attribute and relationship in datastage?

1107

---

What are the main differences you have observed between 7.x and 8.x version of datastage?

1089

---

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 ?

2024

---

How you can fix the truncated data error in datastage?

1794

---

What are some prerequisites for datastage?

1101

---

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

1169

---

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

2179

---

what is flow of project?

2002

---

What are the types of jobs we have in datastage?

1075

---

Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?

2231

---

how to delete one row in target dataset

3123

---

What all are the different way to run a job?

1096

---

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

2722

---