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

Data Stage Interview Questions

Questions Answers Views Company eMail

What modeling tool do you use?

HP,

6 13682

How did you reconcile source with target?

HP,

3 16913

Hi All, Could you please let me know whether Datastage server and px supports oredb? OREDB:It's a Oracle Retail Embedded Database.Previousely It was called as Acumate data base. It's a multidimensional database. Please help me on this issue ASAP. Thanks in advance Ashok

Accenture,

1 8063

what is meta data? Explain? Where it is used?

9 12604

What is lookup table?

5 25432

What is mapping?

3 8382

Explain the functionality of your current project?

IBM, Miles Software,

1 10100

Tell me Wt main advantage of Stage varibles? Project level hints?

Hexaware,

4 14566

project Steps,hits, Project level HArd things,Solved methods?

Hexaware,

2131

if 3 table having different columes. like first table having 4 columns , second table having 3 columns and third table having 2 columns then how to capture the data by using funnel stage in parallel jobs...srinu.thadi

IBM, TCS,

17 43423

what about data stage requirement

1 5260

how can we extract data with out having any common column

IBM, Switch2iTech,

7 17377

WHAT are unix quentios in datastage

TCS,

2 20169

what is the difference between the active datawarehouse and datawarehouse

TCS,

1 14901

what is main difference between change capture and change apply stages

IBM,

4 37821

Post New Data Stage Questions

Un-Answered Questions { Data Stage }

What are the job parameters?

1221

hi iam new to this tooliam cmpltied to know abt datastage so now iam in project tell me whole step by step what iam doing iwnt to go with exp so plz hlp me pals

1872

How do u convert the columns to rows in datastage?

1194

Can you explain tagbatch restructure operator?

1177

create a job that splits the data in the Jobs.txt file into four output files. You will direct the data to the different output files using constraints. • Job name: JobLevels • Source file: Jobs.txt • Target file 1: LowLevelJobs.txt − min_lvl between 0 and 25 inclusive. − Same column types and headings as Jobs.txt. − Include column names in the first line of the output file. − Job description column should be preceded by the string “Job Title:” and embedded within square brackets. For example, if the job description is “Designer”, the derived value is: “Job Title: [Designer]”. • Target file 2: MidLevelJobs.txt − min_lvl between 26 and 100 inclusive. − Same format and derivations as Target file 1. • Target file 3: HighLevelJobs.txt − min_lvl between 101 and 500 inclusive. − Same format and derivations as Target file 1. • Rejects file: JobRejects.txt − min_lvl is out of range, i.e., below 0 or above 500. − This file has only two columns: job_id and reject_desc. − reject_desc is a variable-length text field, maximum length 100. It should contain a string of the form: “Level out of range: ”, where is the value in the min_lvl field. My Question is how do you write the stage variable for reject rows.

2721

What is the method of removing duplicates, without the remove duplicate stage?

1026

What is meta stage?

1180

Explain entity, attribute and relationship in datastage?

1101

how to export or import the jobs in .ISX file

1203

How to reverse the string using unix?

3508

What is the differentiate between data file and descriptor file?

1362

Describe stream connector?

1306

how to delete one row in target dataset

3122

Differentiate between datastage and informatica?

1181

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

1037

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