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
- 10714 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 |
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?
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?
what are the errors,warnings in datastage
which cache supports connected & un connected Lookup
data stores in which location while using data set stage as the target?
What is data partitioning?
WHAT are unix quentios in datastage
HOW CAN YOU DO SCD2 IN DATA STAGE USING SEQUENTIAL FILES?
Hi Can any one help regarding below INPUT NAME LOC Ram hyd Ram ban Raj chn Raj Pun Sam del OUPUT NAME LOC Ram Hyd ban Raj chn pun sam del
Difference between the Sequence and Sequencer in DS?
How do you get log info into a file?
how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.
Teradata 
