Data Stage Interview Questions
Questions Answers Views Company eMail

how can u connect the client system directly at any time?

IBM,

1 6061

HOW U CAN ABORT THE JOB IF THE DATA IS DUPLICATE?

IBM,

1 9997

HOW CAN WE ABORT THE JOB IF THE RECORDS OF SOURCE FILE CONTAINS VALUE AS 'VIJAY'?

Infosys,

1 9435

CAN WE DO HALF PROJECT IN PARALLEL JOBS AND HALF PROJECT IN SERVER JOBS?

Infosys,

2 8334

IS IT POSSIBLE TO USE DATASET AS A SOURCE FILE?

Infosys,

3 12355

can we see the data in fixed width file? how can u change the datatype of fixed width files?

Infosys,

1 8443

types of errors in datastage?

Reliance,

2 8845

on how many columns we can perform aggregation in the Aggregator stage?

Reliance,

3 9766

how can we do null handling in sequential files

Reliance,

2 7550

what is the function in Transformer stage can act as Rank function in Oracle

Reliance,

1 13506

how can we send even and odd records from a sequential file to two different targets

IBM, iGate, TCS,

10 30667

how can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction

Reliance,

1 5030

why we use parameters instead of hard code in datastage

HCL,

4 11609

which memory is used by lookup and join

IBM,

5 11132

when U have a remove dublicate option in sort stage, why we have a remove dublicate stage in PX, thought it is recamended to sort data before using a remove dublicate stage. I hae been thinking this from days....

Target,

4 21978


Post New Data Stage Questions

Un-Answered Questions { Data Stage }

Difference between data warehousing and olap?

641


What is orabulk stage?

619


What is use Array size in datastage

1294


EXPLAIN SCD

949


What are the components of ascential data stage?

640






How rejected rows are managed in datastage?

909


How you can fix the truncated data error in datastage?

1184


Is possible to create skid in dim,fact tables?

2178


Describe the main features of datastage?

648


How do you import and export the datastage jobs?

729


What are the steps needed to create a simple basic datastage job?

645


1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?

1621


how to abort the job its matain duplicates?

2091


Can you implement SCD2 using join, transformer and funnel stage?

1073


How do you generate sequence number in datastage?

617