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
- 9473 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
What are the steps required to kill the job in Datastage?
What is use Array size in datastage
How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?
What is the difference between informatica and datastage?
Describe routines in datastage? Enlist various types of routines.
What is the different type of jobs in datastage?
Explain Quality stage?
Explain datastage architecture?
What is difference between join, merge and lookup stage?
i WANTED TO USE THE RANGE LOOKUP SCENARIO IN DATASTAGE 7.5.2 SRVER JOB.i HAVE A DATE FIELD IN SOURCE AND I SHOULD MATCH IT WITH A FIELD IN LOOKUP FILE.BUT,THE FIELDS SHOULD MATCH EVEN THOUGH THERE IS SOME RANGE.CAN SOMEONE TELL ME HOW CAN I DO THAT. THANKS
How rejected rows are managed in datastage?
What are the difference types of stages?
Define Routines and their types?
how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.
What are the enhancements made in datastage 7.5 compare with 7.0?
