A flatfile 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 the job?pls
give the steps?
Answers were Sorted based on User's Feedback
Answer / venky
first u use sequence generator for the flat file,after that
we take rank transformation in that take top as 50 records
and run the session 4 times it gives 200 records.
| Is This Answer Correct ? | 1 Yes | 6 No |
how to cleansing data
how to export or import the jobs in .ISX file
SOURCE LIKE I_D,F1,F2 --------- 100,N,Y 100,N,N 100,Y,N 101,Y,Y 101,N,Y 102,Y,N 103,N,N 104,Y,Y 105,N,N 106,N,Y 102,N,Y 105,Y,Y O/P LIKE ID flag1 flag2 101 Y Y 101 N Y 102 Y N 102 N Y 104 Y Y 106 N Y
In the source seq file have 2 columns, i.e input: col1,col2 1,1 2,rajesh 3,15000 4,2 5,suresh 6,16000 7,3 8,veeru 9,17000 I want in the output like: eno,ename,sal 1,rajesh,15000 2,suresh,16000 3,veeru,17000 any one answer this scenario
root tree will find which is server job and which is parallel job?
how to define satge variables in transformer stage
I have 2 Files like fileA fileB Output1 Output2 Output3 1 6 1 6 11 2 7 2 7 12 3 8 3 8 13 4 9 4 9 14 5 10 5 10 15 6 11 7 12 8 13 9 14 10 15 please let know
hi i am madan, in real time data stage who is the source provide? and how to recevied in developer? Pls send me answer
IS IT POSSIBLE TO USE DATASET AS A SOURCE FILE?
What are stage variables, derivations and constants?
I have source file which contains duplicate data,my requirement is unique data should pass to one file and duplicate data should pass another file how?
What is the importance of the exception activity in datastage?