Answer / disney

In dataset stage, Input tab of partitioning --> used the key
partition instead of auto partition , then check the
perform sort and check the unique, It will remove the
duplicate from dataset

Answer / markonda

by using remove duplicate stage we can remove duplicates

what is stage is used for below Input columns: dept|mgr|employee|salary Output columns: mgr|count of employee per mgr|avg salary per dept note: each dept has one mgr and each mgr has many employees

0 Answers  

---

What is Horizontal transformation, vertical transformation,diagonal transformation?

2 Answers   Cap Gemini,

---

1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?

0 Answers   Wipro,

---

client know skid info?

0 Answers   NTT Data,

---

How you can fix the truncated data error in datastage?

0 Answers  

---

i have flat file and using unix how can i generate sequence number into targer?

1 Answers   Cap Gemini,

---

How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.

0 Answers   CTS,

---

Hi this madan, in data stage one file in Empno 12345678910 in a table, i want target is  Empno 1                                2 3 4 5 6 7 8 9 10                                                                                             

5 Answers   Tech Mahindra,

---

how to find diff between 2 dates without using Icon... funtions?

1 Answers  

---

1)Source file contains one record, I want 100 records in target file.

3 Answers  

---

A flatfile contains 200 records.I want to load first 50 records at first time running the job,second 50 records at second time running and so on,how u can develop the job?pls give the steps?pls pls

7 Answers   TCS,

---

i want anser this question empno,ename,sal 12,mmm_ww,200 13,nnn_xx,300 14,bbb_qq,400 which stages are take which types of logicks are doing pls help me i don't need "_"ex nnnxx this type i want

3 Answers  

---