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 | 5 No |
Give an idea of system variables.
I am having the 2 source files A and B and I want to get the output as, the data which is in file A and which doesn't in file B to a target 1 and which is in file B and which doesn't in file A to a target 2?
how can we do null handling in sequential files
how to add a new records into source?
What are the some differences between 7.x and 8.x version of datastage?
what is the function in Transformer stage can act as Rank function in Oracle
How many partitions does a node can have? Some body explain me clearly about the partitions and the nodes?
I have 3 jobs A,B and C , which are dependent each other. I want to run A & C jobs daily and B job run only on sunday. how can we do it?
WHAT are unix quentios in datastage
Define APT_CONFIG in Datastage?
Can you implement SCD2 using join, transformer and funnel stage?
How many types of hash files are there?