Interested to Buy Any Domain ? << Click Here >> for more details...
1.How to read multiple file from sequential stage.
2.If a file doesn't arrive or doesn't exists in sequential
stage how do u handle this.
3.What do you do before taking data from source to staging
area.
4. I have a remove duplicate stage and transformer
stage.what will u do for optimizeing the performance of the
job.
- 4 Answers
- 15351 Views
- Syntel, I also Faced
- E-Mail Answers
Answer Posted / varma
Ans1 : We can use Read Method = “Specific Files” and give the full path of all the file one by one. Alternatively, you can use Read Method = “File Pattern” and specify the wild card.
Ans 2: We can control this using “Missing File Mode” Option. Values are “Ok” to skip the file and continue and “Error” to abort the job.
Ans3: It is important to make sure the meta data matches the record. It would be better to reject bad reject and collect them in “Reject Link”. This can be controlled by “Reject Mode” option. Values are “Continue”, “Fail” and “Output”. “Output” will collect the reject records in a reject link.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Define Data Stage?
Distinguish between informatica & datastage. Which one would you choose and why?
How do you run datastage job from the command line?
What is meta stage?
Define ds designer?
How can we improve performance of data stage jobs?
What are routines in datastage?
how to use self join using datastage ? can u tell me using stage how can we implemnet the self join
How to implement complex jobs in data stage?
file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4
how many rows sorted in sort stage by default in server jobs
What are the main differences you have observed between 7.x and 8.x version of datastage?
How do you import and export the datastage jobs?
How to reverse the string using SQL?
What is quality stage?
