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 4865

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

IBM, TCS,

1 6575

what is snow flack schema?

2 5118

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

1600

Why we use parameters instead of hard code in datastage.

IBM,

2 6322

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 4502

How can we do null handling in sequential files?

Reliance,

3 16197

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

Infosys, L&T,

4 9090

what are the different type of errors in datastage?

Wipro,

2 7869

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

3 8739

how to abort the job its matain duplicates?

TCS,

2077

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 5624

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

2 6956

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

Polaris,

1875

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

Polaris,

4 7126


Post New Data Stage Questions

Un-Answered Questions { Data Stage }

How to convert RGB Value to Hexadecimal values in datastage?

3426


Difference between data warehousing and olap?

631


what is the use of surogate key in datastage

1784


Terminate Activity

815


Distinguish between informatica & datastage. Which one would you choose and why?

563






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

656


What is the use of hoursfromtime() function in transformer stage in datastage?

563


Explain datastage architecture?

790


How complex jobs are implemented in datstage to improve performance?

566


What are the types of hashed files in data stage

616


What are the features of datastage flow designer?

601


Define APT_CONFIG in Datastage?

646


What is merge stage?

739


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

629


how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)

495