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
- 13199 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / venkata ramana
Input Seq file:
CodeName
AB1
Aim2
Abnv5
1An8bx
Note: Column(CodeName) lenth is 6
Seq-->Transformar--DataSet
Trasformar:-
In Derivation cell:
Str('0',6 - Len(DSLink3.CodeName)):DSLink3.CodeName
Out put Dataset:-
000AB1
00Aim2
0Abnv5
1An8bx
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.
Define APT_CONFIG in Datastage?
What is the method of removing duplicates, without the remove duplicate stage?
Is it possible to query a hash file?
How many types of stage?
Differentiate between odbc and drs stage?
What is merge stage?
What is datastage?
What are the important features of datastage?
What is the difference between datastage and datastage tx?
1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do
What are the difference types of stages?
table actions available in oracle connector?
How can one find bugs in job sequence?
What is the difference between account and directory options ?
