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
- 15310 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
What are the types of views in datastage director?
What are the some differences between 7.x and 8.x version of datastage?
How one source columns or rows to be loaded in to two different tables?
What are the primary usages of datastage tool?
What is "fatal error/rdbms code 3996" error?
What are the features of datastage flow designer?
Have you used Unstructured data?
In Datastage, how you can fix the truncated data error?
What is the different type of jobs in datastage?
Differentiate between datastage and informatica?
what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?
What is the purpose of interprocessor stage in server jobs?
in oracle target stage when we use load option and when we use upsert option?
what is the use of materialized view?
options available in sequence job to run,validate?
