Data Stage Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Data Stage Interview Questions

Questions Answers Views Company eMail

IN SEQUENTIAL FILE,I HAVE DATA LIKE THIS EID,ENAME 11,AA 11,CC 22,DD 33,EE 22,AA 22,BB 22,CC 11,BB THEN i SELECT perform sort ON eid,uncheck both unique,stable AND I CHOOSE hash SORTING.WHAT IS THE OUTPUT I CAN GET.what happend if i select UNIQUE,STABLE. PLEASE EXPLAIN HOW THE RECORDS DISPLAY AT TARGET.

1 5917

data stores in which location while using data set stage as the target?

IBM, TCS,

1 7488

what is snow flack schema?

2 6490

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

2100

Why we use parameters instead of hard code in datastage.

IBM,

2 7802

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

Infosys, TCS,

1 5782

How can we do null handling in sequential files?

Reliance,

3 18011

can we half project in parallel jobs and half project in server jobs?

Infosys, L&T,

4 10954

what are the different type of errors in datastage?

Wipro,

2 9199

30 jobs are running in unix.i want to find out my job.how to do this?Give me command?

3 10021

how to abort the job its matain duplicates?

TCS,

2623

if the source file is CID,CCODE,CONNDATE,CREATEDBY 0000000224,1000,20060601,CURA 0000000224,2000,20050517,AFGA 0000000224,3000,20080601,TUNE 0000000225,1000,20020601,CURA 0000000225,2000,20050617,AFGA 0000000225,3000,20080601,TONE AND TARGET is oracle following are the validations cid loaded with unique records leading zeors has to be deleted while loading cid in target load only customer who got early connected to company conn_date should be loaded into oracle date format cid datatype is varchar2 in target conn_date is data datatype ccode is varchar2 0000000224,1000,20060601,CURA 0000000224,1000,20060601,CURA

2 6586

can any one tell me how to install datastage 8.1 in windows xp with wizard

2 7959

I have a few records just I want to store data in to targets cycling way how?

Polaris,

2414

I have a few records all are same structures data, I want to store data in multiple targets how?

Polaris,

4 9031

Post New Data Stage Questions

Un-Answered Questions { Data Stage }

What is size of a transaction and an array means in a datastage?

1366

Which commands are used to import and export the datastage jobs?

1462

What is the importance of the exception activity in datastage?

1111

how to run a sequential file stage in parallel if the stage is used on the TARGET side

1795

What is the precedence of stage variables,derivations, and constraints?

1126

Differentiate between datastage and informatica?

1249

What all are the different way to run a job?

1139

Triggers,VIEW,Procedures

1265

How the ipc stage work?

1170

im new to this tool im now at project plz tell me step by step process how to design plz help me i wnt to go with exp for job plz give me d proper design and explination

2258

Differentiate between validated and Compiled in the Datastage?

1355

How to convert RGB Value to Hexadecimal values in datastage?

4057

How do you register plug-ins?

997

Name the third party tools that can be used in datastage?

1138

How do you run datastage job from the command line?

1129

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