Answer / rajesh

1)first sort d data in accending order based on date and remove duplicates
2)in transformer write a derivation to delete leading zeros by using function trim. eg- trim(col 1)
3)change date format by using date functions in transformer
4)change d data types to be fitted according to following ask

Answer / supriya

Use Sort stage to get unique recs,write a constraint in the
transformer to remove leading zeros by usig Trim
function.In XFM it sims we can change the datatypes of
required fields.

what is the difference between lookup stage reject link and merge stage reject link in datastage Parallel jobs?

9 Answers   HCL,

---

What can we do with datastage director?

0 Answers  

---

What are the some differences between 7.x and 8.x version of datastage?

0 Answers  

---

How to generate surrogate key without using surrogate key stage?

6 Answers   IBM,

---

Unix Qn asked in datastage interview: I have diff type(.txt, .tmp, .bat etc) of file in 4 diff directories, I want move all '.txt' file from 4 directories to other folder. And need to delete all the files except which are created TODAY?

2 Answers   TCS,

---

Hi guys, please design a job with derivation(solution). write exact conditions. My requirement Source table emp_no qualification 1 a 1 c 2 a 3 c 3 b Target table emp_no qualification 1 b 2 b 2 c 3 a Here every employer have three qualifications i.e a,b and c. what ever source table dont have some qualification, that will be move to target table. Like above. Hope u get the point. Thanks.

4 Answers   UHG,

---

Difference between server jobs & parallel jobs?

0 Answers  

---

what is a force compile

2 Answers   Cap Gemini, IBM,

---

How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?

0 Answers   Reliance,

---

How to remove blank spaces from data?

3 Answers  

---

can a fact table contains textual information

6 Answers   HCL, HCL BSERV, IBM,

---

detail about sdlc

4 Answers  

---