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 / jayanthi
1)read method should be set as file pattern(for reading
single file it should be specificfile)
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Can you explain players in datastage?
What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?
What is the purpose of pivot stage?
Explain how a source file is populated?
What are the features of datastage flow designer?
What is orabulk stage?
Is possible to create skid in dim,fact tables?
for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr
How many areas for files does datastage have?
if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables? how can i implement scd typ1 and type2 in both server and in parallel? field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the duplicate rows,inthe fields?
What are constraints and derivations?
How many types of sorting methods are available in datastage?
What are routines in datastage? Enlist various types of routines.
what is the use of skid in reporting?
what are the errors,warnings in datastage