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?
Answer Posted / 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 | 5 No |
Post New Answer View All Answers
What is the command line function to import and export the ds jobs?
1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)
What are the steps needed to create a simple basic datastage job?
What are transforms and what is the differenece between routines and transforms?
What is datastage?
What are the components of datastage?
How a server job can be converted to a parallel job?
I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this
What is the method of removing duplicates, without the remove duplicate stage?
What is orabulk stage?
What are the different kinds of views available in a datastage director?
What is the difference between the local container and shared container?
What is ds designer?
What are the stages in datastage?
What is a merge in datastage?