Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 5 Answers
- 11046 Views
- Tech Mahindra, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / david
by using right and left function with loop function we can achieve this one
| Is This Answer Correct ? | 1 Yes | 3 No |
Answer / vijau
in sequential file stage just execute unix command head -1 command
| Is This Answer Correct ? | 0 Yes | 4 No |
Answer / xyz
use remove duplicate stage with first as the option for duplicate to return
| Is This Answer Correct ? | 0 Yes | 15 No |
What is the difference between hashfile and sequential file?
How to create a doccument in datastage?
What is the surrogate key? what is the use of surrogate key? how to Create surrogate key Generator in scd2 in 8.5?
I have a few records just I want to store each records tow times in target how?
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
Lookup constraints
What is use Array size in datastage
A flat file contains 200 records. I want to load first 50 records at first time running the job, second 50 records at second time running and so on, how u can develop this job?
j1,j2,j3 jobs r runing iwant to run j1,j3 after j2 how to do this using sequencer? 2)j1,j2,j3 jobs r runing iwant to run j1,j2,j3 how to do this?
How can i approach to write datastage 7.5 Certification? and how much they will charge for examination .What exactly should i do? Can anyone guide me plz?
hi i am madan, in real time data stage who is the source provide? and how to recevied in developer? Pls send me answer
how many dimentions and fact tables used in your project and what are names of it?
Teradata 
