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
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 |
Hi Vijay here For Four CPU's how many nodes will required?
Notification Activity
How to LOG 'unmatched Master' records and 'Reject Updates' in log files using MERGE stage?
WHERE YOU USE UNIX COMMANDS AS A ETL DEVELOPER?
What is difference between 8.1 , 8.5 and 9.1 ?
what are the types of nodes
what is A Datastage?
what is the exact difference between dataset and fileset in datastage?
in sequtial file 2 columns avaliable,iwant only one column load the target how do it.
Source have 1000 records and it can have three nodes ok but i want how many records are executed on each node?
How to exclude first and last lines while reading data into a sequential file(having some 1000 records).I guess probably by using unix filter option but not sure which to use
What is process model?