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


Please Help Members By Posting Answers For Below Questions

What is quality stage?

574


Difference between data warehousing and olap?

653


What is the project in datastage?

669


What is "fatal error/rdbms code 3996" error?

663


Why fact table is in normal form?

678






root tree will find which is server job and which is parallel job?

1455


What are datastage sequences?

672


What could be a data source system?

579


What is the flow of loading data into fact & dimensional tables?

598


What can we do with datastage director?

675


Whats difference betweeen operational data stage (ods) and data warehouse?

671


which r the connectors used in san?

1790


table actions available in oracle connector?

1096


What are the functionalities of link partitioner?

620


How can you write parallel routines in datastage PX?

620