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)
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
Differentiate between hash file and sequential file?
Why we use surrogate key?
Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.
How do you import and export the datastage jobs?
how to delete one row in target dataset
What is difference between join, merge and lookup stage?
What are the areas of application?
explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?
What is the precedence of stage variables,derivations, and constraints?
Name the different types of Lookups in Datastage?
How do you register plug-ins?
What are the components of ascential data stage?
Differentiate between datastage and datastage tx?
How a server job can be converted to a parallel job?
1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do