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 |
What are the types of containers in datastage?
how to delete one row in target dataset
what is repositery?
i have the source from Uk,north america how can i pass the data two tables based on the locations
How to implement complex jobs in data stage?
What is the difference between orabulk and bcp stages?
Is the value of staging variable stored temporarily or permanently?
What is RCP
What is the purpose of interprocessor stage in server jobs?
Two source files contains same meta data third file contains different data types can I funnel that file.
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)
Hi all, explain one complex business rule that you had in your project and how did you accomplish it using DS?