Hi Every one,
I have a scenario plz suggest me
1)On daily we r getting some huge files data so all files
metadata is same we have to load in to target table how we
can load?
2) One column having 10 records at run time we have to send
5th and 6th record to target at run time how we can send?
Hi plz help me for above scenarios and If any one is having
JobSequence kindly send me one example and the scenario to
my mail ID(nrvdwh@gmail.com)
- 3 Answers
- 8832 Views
- HSBC, I also Faced
- E-Mail Answers
Answer Posted / akila ramu
Sample stage can be used for this. Sample stage when run in
period mode and N is mentioned, every Nth record from the
input is sent to the output.
For eg., period number=5 and maximum value=20 then 5, 10,
15 and 20th records are alone sent to the output.
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
How a source file is populated?
On which Dimension Table you implemented SCD Type in your Project
What are the important features of datastage?
Define data aggregation?
How you can fix the truncated data error in datastage?
how to use self join using datastage ? can u tell me using stage how can we implemnet the self join
What are the job parameters?
Difference between ‘validated ok’ and ‘compiled’ in data stage?
Explain the situation where you have applied SCD in your project?
CHANGE CAPTURE
Hi All , in PX Job I have passed 4 Parameters and when i run the same job in sequence i dont want to use those parameters , is this possible if yes then how
What is the project in datastage?
client know skid info?
What is the differentiate between data file and descriptor file?
Terminate Activity
