Answer Posted / bharath

hi,
please take a look on below,


seq_src------->ext_flter----->seq_tgt

in external filter give the
filter command = sed s/"&"/" And "/g command.

**Note: on ampersand (&) symbol you must give the double
quotes (""). With out this it doesn't populate.

Differentiate between data file and descriptor file?

1001

---

In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?

1002

---

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?

2139

---

Can you explain players in datastage?

1157

---

How do you schedule or monitoring the job?

1148

---

What is the difference between the local container and shared container?

1050

---

hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys

2832

---

how to implement scd2 in datastage 7.5 with lookup stage

5562

---

What is usage analysis in datastage?

1274

---

What are the steps required to kill the job in Datastage?

1164

---

how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)

876

---

What are datastage sequences?

1069

---

What are the components of ascential data stage?

1127

---

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

739

---

Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC

1377

---