Answer Posted / 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
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
Difference between sequential file and data set?
What is datastage engine?
What is the purpose of pivot stage?
Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?
how can we create rank using datastage?what is the meaning of rank?
What is the difference between validated and compiled in the datastage?
State the difference between an operational datastage and a data warehouse?
What is the roundrobin collector?
what is the use of skid in reporting?
how to run a sequential file stage in parallel if the stage is used on the TARGET side
what is flow of project?
What are routines in datastage?
If you want to use the same piece of code in different jobs, how will you achieve it?
Can you filter data in hashed file?
what are the errors,warnings in datastage