Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

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 3870

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

IBM, TCS,

1 5615

what is snow flack schema?

2 3879

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

1241

Why we use parameters instead of hard code in datastage.

IBM,

2 5246

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 3366

How can we do null handling in sequential files?

Reliance,

3 14906

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

Infosys, L&T,

4 7240

what are the different type of errors in datastage?

Wipro,

2 6387

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

3 7466

how to abort the job its matain duplicates?

TCS,

1703

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 4711

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

2 6205

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

Polaris,

1519

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

Polaris,

4 5459


Post New Data Stage Questions






Un-Answered Questions { Data Stage }

1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.

3073


How can one find bugs in job sequence?

313


What is the difference between server job and parallel jobs?

262


Give an idea of system variables.

207


Can you explain engine tier in information server?

217






8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?

1330


Difference between data warehousing and olap?

244


What are the benefits of datastage?

228


how to delete one row in target dataset

2191


How complex jobs are implemented in datstage to improve performance?

223


A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?

1525


What is the sortmerge collector?

246


What are the different plug-ins stages used in your projects?

228


in oracle target stage when we use load option and when we use upsert option?

1361


What is the purpose of pivot stage and types of containers in datastage

213