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 |
How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.
What is the function in Transformer stage can act as Rank Function in oracle
there are indexes on a table as index1 with col1, col2 index2 with col2 index3 with col1,col2,col3. if i run a query with col1='100' which index will be used and why
What is mapping?
Define Merge?
If seg file having 10 records ex:eid 1 2 " " 10 if oracle database having 100 records ex:eid 1 2 " " 100 how to delete matched records permenently from oracle database using datastage ?
i want send my all duplicate record one tar and all uniq records one target how we will perfome explain example: input data eid 251 251 456 456 951 985 out put/target1 251 251 456 456 out put/target2 951 985 how we will bring
13 Answers Bank Of America, IBM,
What is the different type of jobs in datastage?
how do u catch bad rows from OCI stage? And what CLI stands for?
what will happen if we allow duplicates in datastage lookup abort drop record 1st value of duplicate record none
Define oconv () and iconv () functions in datastage?
What is the difference between hashfile and sequential file?