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.
Post New Answer View All Answers
How to manage date conversion in Datastage?
Explain the situation where you have applied SCD in your project?
Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?
On which Dimension Table you implemented SCD Type in your Project
What are the main differences you have observed between 7.x and 8.x version of datastage?
What is the sortmerge collector?
What are some different alternative commands associated with "dsjob"?
How do y read Sequential file from job control?
In Informatica,for the table I can find coreesponding dependent mappings.Likewise can I find the dependent jobs with all the information by using the table name
1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)
How do you remove duplicate values in datastage?
In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?
How many types of sorting methods are available in datastage?
What could be a data source system?
What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?