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 / prasad
yo ca use while loop to get this output take two loop variables one is for condtion in condition you should write like variable<=len(inputlink.string) and in loop variable use inputlink(indexnum,1) then you will get output like what you wanted
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are system variables and sequencers in datastage
Describe the architecture of datastage?
What are the components of ascential data stage?
Define ds designer?
What are some different alternative commands associated with "dsjob"?
how do u catch bad rows from OCI stage? And what CLI stands for?
Have you have ever worked in unix environment and why it is useful in datastage?
how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara
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 is staging variable?
Where do you see different stages in the designer?
What are the important features of datastage?
Explain Quality stage?
How rejected rows are managed in datastage?
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)