Answer Posted / reddymkl.dwh

Use Transformer Stage:
Take stage variable,
sv1 = sv1 : ' ' : DSLink.EMPNAME
Derivation : Trim(sv1, ' ','L')
U will get output.

What are the primary usages of datastage tool?

1017

---

What are the types of containers and how to create them?

931

---

Differentiate between hash file and sequential file?

998

---

What is the command line function to import and export the ds jobs?

1096

---

What is ibm datastage?

915

---

Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2

725

---

What is process model?

1920

---

How you can fix the truncated data error in datastage?

1674

---

What is the sortmerge collector?

1081

---

if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables? how can i implement scd typ1 and type2 in both server and in parallel? field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the duplicate rows,inthe fields?

2131

---

What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?

2925

---

Differentiate between odbc and drs stage?

997

---

what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?

1331

---

table actions available in oracle connector?

1555

---

file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4

887

---