Hi this madan, in data stage one file in Empno 12345678910 in a table, i want target is
Empno
1
2
3
4
5
6
7
8
9
10
Answer Posted / david
by using right and left function with loop function we can achieve this one
| Is This Answer Correct ? | 1 Yes | 3 No |
Post New Answer View All Answers
What is the difference between the local container and shared container?
What steps should be taken to improve Datastage jobs?
What is a merge?
Differentiate between datastage and datastage tx?
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
I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this
how to implement scd2 in datastage 7.5 with lookup stage
Which algorithm you used for your hashfile?
What are the difference types of stages?
What is ds designer?
How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.
Can you define merge?
Explaine the implimentation of scd's in ds indetail, please send me step by step procedure to perform scd's 1,2,3. Please replay for this, Thanks in advance
Enlist various types of routines in datastage.
What are the partitioning techniques available in link partitioner?