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
- 15140 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 project in datastage?
what are the devoleper roles in real time? plz tell i am new to datastage....
What are the different types of lookups in datastage?
Could anyone give brief explanation bout datastage admin
Highlight the main features of datastage?
Explain the datastage parallel extender (px) or enterprise edition (ee)?
What is the difference between validated and compiled in the datastage?
tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise
hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys
Is it possible to query a hash file?
How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.
Notification Activity
Explain ibm infosphere information server and highlight its main features?
Differentiate between data file and descriptor file?
Whats difference betweeen operational data stage (ods) and data warehouse?
