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 |
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
when will you go for dataset and fileset?
how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?
What are the different layers in the information server architecture?
count number of deptno in a emp table?
what is 'reconsideration error' and how can i respond to this error and how to debug this
1.i have 5 jobs(1-5),i connect with each other,i want run from 3-5 only how? 2.how to schedual the job in datastage7.5 2? what is the deff bet grip and fgrep command? how do you cleanse the data in your project
If I make any changes in the parallel job,do I need to implement the changes in the sequencer job,else the changes will be reflected automatically
file1 1 2 3 4 file2 3 4 5 6 output should be in three targets T1 T2 T3 1 3 5 2 4 6 how to do this? can any one help? Thanks
How to enter a log in auditing table whenever a job get finished?
Nls stands for what in datastage?
Hi all, can u explain header and trailer records in file? If a file has header and trailer /master-detail records how will you read it in datastage?