Answer Posted / mahalakshmi

SRC--SRT---FLT---|
| LKP
CPY---| |
| |
|__FNL_|
|
TGT
1.In Sort Stage (Keys on Empid & Emp Ind), Create Key
changeColumn = True
2. In Filter WhereClause-(Keychange=0)OutputLink=0
WhereClause-(Keychange=1)OutputLink=1
3.In Lookup InnerJoin on EmpId
4.In Funnel, Funnel Type=Sorted Funnel

Where the datastage stored his repository?

1090

---

How to manage date conversion in Datastage?

1142

---

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

1253

---

1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?

2277

---

1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do

2089

---

EXPLAIN SCD

1413

---

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?

2182

---

How we can covert server job to a parallel job?

1154

---

What are some prerequisites for datastage?

1105

---

Can anyone tell me a difficult situation who have handled while creating Datastage jobs?

3250

---

what is 'reconsideration error' and how can i respond to this error and how to debug this

2634

---

How rejected rows are managed in datastage?

1526

---

What is the difference between datastage and datastage tx?

1071

---

how to delete one row in target dataset

3125

---

What are the types of views in datastage director?

1776

---