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 function in Transformer stage can act as Rank function in Oracle

1 Answers   Reliance,

---

create a job to get the previous row salary for the current row.if there is no previous row exists for the current row,then the previous row salary should be displayed as null? empid   salary   previoussalary 10      1000     null 20      2000     1000 30      3000     2000       40      4000     3000

5 Answers   Genpact,

---

detail about sdlc

4 Answers  

---

What is a merge in datastage?

0 Answers  

---

How to display all the duplicate records from the oracle Table?

3 Answers   IBM,

---

---

Describe link sort?

0 Answers  

---

How do you register plug-ins?

0 Answers  

---

tab1 tab2 1,a 1,d 2,b 3,c perfoms outerjoin what is the o/p? write sql query for outerjoin?

3 Answers   Infotech,

---

describe the Steps to confiure a Qlogic switch

0 Answers   IBM,

---

hi everbody, i have a problem in my project.. Native Error Code: -407 "Assignment of a null value to a not null column"  hi everbody, i have a problem in my project.. Native Error Code: -407 "Assignment of a null value to a not null column" i have no idea, what should i do..please help :(

3 Answers  

---

what is executable in DataStage?

2 Answers  

---

What is the difference b/w Hash file and Lookup Fileset stages?

1 Answers  

---