Answer / santhu

Sorry its not String we shoud use str("0",1)

Answer / ranjan

use the below function to add "0" in transformer

"0" : fieldname

Answer / santhu

Ranjan is right but when we want add 4 zeros("0")then By Using String Function we can do that

String("o",1):Column name
Here 1 is how many zeros we want

Answer / dhanasekar

Str(%string%,%repeats%) is the function used in transformer to repeat a string for a number of times we required.

%String%-> represents the string we want to repeat
%repeats%->its a no represents how many times the string to be repeated.

Example: Str("0",1):Column_name

in sequtial file 2 columns avaliable,iwant only one column load the target how do it.

10 Answers   Wipro,

---

what is difference between migration project and integration project? can anyone explain with the example Thanks in advance

2 Answers   Satyam,

---

if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?

1 Answers   IBM,

---

Hi All, Could you please let me know whether Datastage server and px supports oredb? OREDB:It's a Oracle Retail Embedded Database.Previousely It was called as Acumate data base. It's a multidimensional database. Please help me on this issue ASAP. Thanks in advance Ashok

1 Answers   Accenture,

---

we run a job in 4 nodes,i want to run same job on 8 nodes is it possible? job recompling is mandtory?why?

1 Answers   HSBC, NTT Data,

---

How to generate surrogate key without using surrogate key stage?

6 Answers   IBM,

---

In merge stage can we update the values?

3 Answers   TCS,

---

Have you used Unstructured data?

0 Answers   CTS,

---

Can we use target hash file as a lookup ?

0 Answers  

---

What is the difference between odbc and drs stage?

0 Answers  

---

How to convert table data into xml file using xml output stage? please explain step by step;

2 Answers   IBM,

---

hi this is kiran i have one table i want divide the table with two different table like even rows and odd rows how can i do this one tell me plzz

4 Answers  

---