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
What is difference between symmetric multiprocessing and massive parallel processing?
What is the use of datastage director?
Why do you need stage variables?
Which algorithm you used for your hashfile?
1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.
What are the steps required to kill the job in Datastage?
What is oci?
How to read the length of word in unix?
Explain Quality stage?
Which commands are used to import and export the datastage jobs?
in oracle target stage when we use load option and when we use upsert option?
What is job control?
What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?
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
What are the different common services in datastage?