Answer Posted / nagam

seq.file----->sort------>filter----2datasets

in sort stge create key change column and then filter stage
write the condition on based on keychange column keychange
column =1 uniq data keychange<>0 duplicate data we can get

If wrong please tell me

How to convert RGB Value to Hexadecimal values in datastage?

3456

---

Notification Activity

895

---

What are the repository tables in datastage?

819

---

What is the difference between validated and compiled in the datastage?

699

---

What all are the different way to run a job?

639

---

---

What is a ds designer?

640

---

How many areas for files does datastage have?

640

---

What is the process of killing a job in datastage?

589

---

What are the steps required to kill the job in Datastage?

682

---

What are the types of hashed files in data stage

642

---

If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?

1624

---

What is the flow of loading data into fact & dimensional tables?

593

---

tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise

2702

---

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

582

---

How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?

1695

---