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.
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 meta stage?
How do you start developing a datastage project?
What is staging variable?
CHANGE CAPTURE
How do you schedule or monitoring the job?
What is the use of datastage designer?
What are the enhancements made in datastage 7.5 compare with 7.0?
What are the difference types of stages?
how to sort two columns in single job in datastage.
how to run a sequential file stage in parallel if the stage is used on the TARGET side
Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?
What are the functionalities of link partitioner?
What are the job parameters?
What is ibm datastage?
To see hidden files in LINIX?