1. Categories >> Software >> Data Warehouse >> Data Stage
  2. Suggest New Category
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 4903

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

IBM, TCS,

1 6624

what is snow flack schema?

 2 5216

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

 1624

Why we use parameters instead of hard code in datastage.

IBM,

2 6391

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 4573

How can we do null handling in sequential files?

Reliance,

3 16264

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

Infosys, L&T,

4 9191

what are the different type of errors in datastage?

Wipro,

2 7920

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

 3 8794

how to abort the job its matain duplicates?

TCS,

2101

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 5675

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

 2 6995

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

Polaris,

1896

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

Polaris,

4 7205

Post New Data Stage Questions

Un-Answered Questions { Data Stage }

Can you highlight the main features of ibm infosphere information server?

635

What are orabulk and bcp stages?

645

what is stage is used for below Input columns: dept|mgr|employee|salary Output columns: mgr|count of employee per mgr|avg salary per dept note: each dept has one mgr and each mgr has many employees

657

On which Dimension Table you implemented SCD Type in your Project

1577

What is job control?

622




What is merge stage?

760

What is the project in datastage?

665

What is a merge in datastage?

765

What is staging variable?

622

what are the errors,warnings in datastage

2145

Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?

3376

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

1801

Define data aggregation?

664

tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise

2702

Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.

1615

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