Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 9986 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 do you generate sequence number in datastage?
Lookup constraints
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 is the precedence of stage variables,derivations, and constraints?
What are the areas of application?
What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)
What are the functionalities of link partitioner and link collector?
How rejected rows are managed in datastage?
Can you implement SCD2 using join, transformer and funnel stage?
What is a merge in datastage?
What are the different common services in datastage?
Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.
how to add a new records into source?
Difference between sequential file and data set?
What are the types of jobs we have in datastage?
