Answer Posted / abdullah

read answer 2 first because i`m appending this answer to it so u can understand more.

*change capture views you the records that were change only, without telling you the rest of of the original records
ex: if one records was changed among 5 records then it will view it alone.
-(it will take two input, the before data set and the after data set)

*change apply should take the original data set and the change capture data set and then apply the change to the original copy as an output. as a result you have now all the records including the new and changed ones.

What are the functionalities of link collector?

1035

---

What is size of a transaction and an array means in a datastage?

1236

---

How complex jobs are implemented in datstage to improve performance?

961

---

Can you highlight the main features of ibm infosphere information server?

1044

---

What is usage analysis in datastage?

1261

---

What are the stages in datastage?

1026

---

There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this

2196

---

What are the partitioning techniques available in link partitioner?

2225

---

What are the areas of application?

1090

---

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?

2130

---

How do you generate sequence number in datastage?

1025

---

Could anyone give brief explanation bout datastage admin

2310

---

Difference between data warehousing and olap?

1041

---

Hi All , in PX Job I have passed 4 Parameters and when i run the same job in sequence i dont want to use those parameters , is this possible if yes then how

1504

---

What is the sortmerge collector?

1080

---