Answer Posted / amjad pasha

SOURCE ---> SORT STAGE(sort key mode = sort, create cluster
key change column and create key change column should be
false) ---> COPY STAGE ---> (2 REMOVE DUPLICATE STAGES)
REMOVE DUPLICATE STAGE_1 (key=dept and Duplicate to Retain
= First) AND REMOVE DUPLICATE STAGE_2 (key=dept and
Duplicate to Retain = Last) ---> FUNNEL STAGE (Funnel
Type=Continues Funnel) ---> TARGET

What are the types of containers in datastage?

1143

---

How to find value from a column in a dataset?

2149

---

What are the different types of lookups in datastage?

1006

---

Enlist various types of routines in datastage.

1185

---

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

1025

---

What are the enhancements made in datastage 7.5 compare with 7.0?

1095

---

What are the types of containers and how to create them?

933

---

How to read multiple files using a single datastage job if files have the same metadata?

1179

---

How do y read Sequential file from job control?

15802

---

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

1046

---

What is the process of killing a job in datastage?

963

---

what are the devoleper roles in real time? plz tell i am new to datastage....

2101

---

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?

2133

---

What are the job parameters?

1161

---

Differentiate between datastage and informatica?

1141

---