Answer / srinivas

Its purely based on stages witch we have used in the project and some times its depends on the data witch we have from source system.

Like if we use Sort,Aggregator stages will use key based partitions.

What are data elements?

0 Answers  

---

what is ds administrator used for?

0 Answers  

---

Explain the importance of surrogate key in data warehousing?

0 Answers  

---

What are the features of datastage flow designer?

0 Answers  

---

What are the different layers in the information server architecture?

0 Answers  

---

i have source data like empno,enmae 11 ,aa 12 ,bb i want output like empno,ename 11 ,aa 12 ,bb 11 ,aa 12 ,bb

7 Answers   TCS,

---

Hi dude, i/p eno ename date edate deptno 1 x 10thjuly 30july A 2 y 10th aug 30 aug B 1 x 1aug ------ A 3 z 1jan ------ c 2 y 1sep ------ B o/p is eno ename date edate deptno 1 x 1aug ------ A 2 y 1sep ------ B 3 z 1jan ------ c Here edate is System generates we don't know that value. Please design the job by using SCD stage and Sql query. If any body know this answer please tel me. Tanks.

1 Answers   Amdocs,

---

Lookup constraints

0 Answers   CTS,

---

In my project source data comes from MAINFRAME in files.so,This time data is coming as a binary file...I know for binary data we use Complex flat file stage..I have used it also..but on 'view data' data is not coming correctly..as it in MAINFRAME.give me some ideas..

2 Answers  

---

how can we create rank using datastage?what is the meaning of rank?

0 Answers   IBM,

---

1.what is stagearea?what is stage variable? 2.this is my source source:id, name target:id, name 100, murty 100,madan we have three duplicate records for the id column,how can we getthe source record? 100,madan 100,saran

1 Answers   HCL,

---

how to cleansing data

6 Answers   Cap Gemini,

---