Answer Posted / anki_sri

Src>> Sort1 >> Sort2 >> Transfrmr >> Trgt

Sort1 --> sort with class_id and marks as well.
Sort2 --> declare key as id and select Dont Sort(Previously Sorted) and set create cluster key change column as True.

Transfrmr --> set two stage variables.
StageVar1=If Clusterkeychange=1 then Clusterkeychange else StageVar+1

StageVar=StageVar1
Create a new row as rank in transfrmr output and map StageVar1 to rank

Why fact table is in normal form?

1260

---

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

2277

---

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

3126

---

What are the different kinds of views available in a datastage director?

1032

---

Hi guys, Please design a job for dis requirement with derivation(solution). my source table like dis. emp_no qualification 1 a 1 c 2 a 3 c 3 b To loaded to target like dis emp_no qualification 1 b 2 b 2 c 3 a my requirement is every employer have three qualifications i.e a,b and c. what qualification missed in source table that will be move to target systems. Hope u got it the requirement. Right Thanks.

2907

---

Where the datastage stored his repository?

1089

---

Name the different sorting methods in datastage.

1058

---

Explain connectivity between datastage with datasources?

985

---

hi iam new to this tooliam cmpltied to know abt datastage so now iam in project tell me whole step by step what iam doing iwnt to go with exp so plz hlp me pals

1873

---

How many Key we can define in remove duplicate stage?

1390

---

What are the various kinds of containers available in datastage?

1048

---

What is ds designer?

1109

---

In Datastage, how you can fix the truncated data error?

1163

---

Explain the importance of surrogate key in data warehousing?

1192

---

Name the different types of Lookups in Datastage?

1263

---