Interested to Buy Any Domain ? << Click Here >> for more details...
My source having following data as below,
AB1
Aim2
Abnv5
1An8bx
and my question is i need the Datastage job the following
as in my target
000AB1
00Aim2
0Abnv5
1An8bx
Please help me to achive this.
- 6 Answers
- 13385 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / d
Str('0',6-Len(string)): string
| Is This Answer Correct ? | 17 Yes | 0 No |
Post New Answer View All Answers
What are the components of datastage?
i WANTED TO USE THE RANGE LOOKUP SCENARIO IN DATASTAGE 7.5.2 SRVER JOB.i HAVE A DATE FIELD IN SOURCE AND I SHOULD MATCH IT WITH A FIELD IN LOOKUP FILE.BUT,THE FIELDS SHOULD MATCH EVEN THOUGH THERE IS SOME RANGE.CAN SOMEONE TELL ME HOW CAN I DO THAT. THANKS
What is the different type of jobs in datastage?
Define data aggregation?
how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?
How to manage date conversion in Datastage?
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.
How do you reject records in a transformer?
explain about citrix scheduling tool in datastage
What is the method of removing duplicates, without the remove duplicate stage?
How to read the length of word in unix?
What are the main differences you have observed between 7.x and 8.x version of datastage?
Explain the importance of surrogate key in data warehousing?
How to Remove Duplicate using SQL?
What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)
