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
- 15531 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
Demonstrate experience in maintaining quality process standards?
What is difference between server jobs & parallel jobs?
What is the difference between an operational datastage and a data warehouse?
Explain the importance of surrogate key in data warehousing?
What is the difference between Datastage 7.5 and 7.0?
Difference between in process and inter process?
Hi All , in PX Job I have passed 4 Parameters and when i run the same job in sequence i dont want to use those parameters , is this possible if yes then how
What are the different plug-ins stages used in your projects?
Give an idea of system variables.
State the difference between an operational datastage and a data warehouse?
How many areas for files does datastage have?
What are the functionalities of link partitioner?
What is apt_config in datastage?
what are the errors,warnings in datastage
Explain how a source file is populated?
