1. Categories >> Software >> Data Warehouse >> Data Stage
  2. Suggest New Category
Data Stage Interview Questions
Questions Answers Views Company eMail

if we take 2 tables(like emp and dept), we use join stage and how to improve the performance?

Cap Gemini,

5 13403

how to create document in datastage?

Cap Gemini,

1 6166

how to transfer file from one system to another system in unix? which cmd to be use?

Cap Gemini,

5 13553

when u face critical situation in ur project, how to solve them?

Toyota,

1 9466

explain unit testing,systemtesting,integrated testing

CSC,

1 6217

how many stages are there in Datastage... Please clarify mee??

 3 7214

what is the best stage in datastage parller jobs to use full out join and why

Virtusa,

5 14049

I have oracle enterpaise stage, oracle bulkloader stage, ODBC stage and I want to load data in to target, which of the above stages do I need to use and why?

Virtusa,

3 11693

Explaine the implimentation of scd's in ds indetail, please send me step by step procedure to perform scd's 1,2,3. Please replay for this, Thanks in advance

 1736

in sequtial file 2 columns avaliable,iwant only one column load the target how do it.

Wipro,

10 13581

insequential file 2header avaliable,and 100 records avaliable.how to skip the 2 headers and load 100 records target?

 5 8337

I have scenario like this seq file --> transformer --> sort stage --> dataset In this job which prtitioning technique you are using and why???

CTS, IBM,

3 20869

how can we create a Sorrogate key in transformer stage? I want it in parallel mode

Syntel,

2 11547

How to remove duplicates in transformer stage? in parallel mode

Syntel, TCS,

6 15196

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.

Syntel,

4 13491

Post New Data Stage Questions

Un-Answered Questions { Data Stage }

There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this

1795

1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)

2303

What is quality stage?

560

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

1113

Highlight the main features of datastage?

610




what is flow of project?

1547

How rejected rows are managed in datastage?

909

What steps should be taken to improve Datastage jobs?

631

What is the command line function to import and export the ds jobs?

670

What all are the different way to run a job?

633

What is job control?

616

What is the importance of the exception activity in datastage?

614

Demonstrate experience in maintaining quality process standards?

1916

How to find value from a column in a dataset?

1759

i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu

2263

For More Un-Answered { Data Stage } Questions Click Here