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

What are the enhancements made in datastage 7.5 compare with 7.0?

0 Answers  

---

How you Implemented SCD Type 1 & Type 2 in your project?

0 Answers  

---

Please tell me What is difference between 8.0 and 8.1

1 Answers   IBM,

---

Hi guys, Please design a job for dis requirement with derivation(solution). my source table like dis. emp_no qualification 1 a 1 c 2 a 3 c 3 b To loaded to target like dis emp_no qualification 1 b 2 b 2 c 3 a my requirement is every employer have three qualifications i.e a,b and c. what qualification missed in source table that will be move to target systems. Hope u got it the requirement. Right Thanks.

0 Answers  

---

Have you used Unstructured data?

0 Answers   CTS,

---

1.how to generate even numbers in surrogate or tranformar stage ? 2. how many ways to remove duplicate values?

5 Answers   Gallega, TCS,

---

wt is the diff b/w odbc and oracle stage

2 Answers   Accenture, HCL,

---

I have 2 jobs.I want to ru job B if job A has run 3 times.How can I achieve this through datastage

3 Answers   IBM,

---

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

0 Answers   CTS,

---

Tell me Wt main advantage of Stage varibles? Project level hints?

4 Answers   Hexaware,

---

In a table 100 records are there after 50records job is aborted how can u insert all records in target table.

1 Answers   Cap Gemini,

---

I have a few records all are same structures data, I want to store data in multiple targets how?

4 Answers   Polaris,

---