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

Data Stage Interview Questions

Questions Answers Views Company eMail

How to lode data in sequntional files perform faster?

Polaris,

1 4240

I have a few records just I want to store each records tow times in target how?

Polaris,

2 7450

What is diff between Junk dimensions and conform dimension?

Polaris,

4 12525

i 10 jobs first two jobs are runing in 2nodes,next 2 jobs are running in 4 nodes, next 4 jobs are running in 6 nodes and the remaining jobs are running on 10 nodes. how to change the node configuration?

2 6289

how to use self join using datastage ? can u tell me using stage how can we implemnet the self join

5121

what is difference between migration project and integration project? can anyone explain with the example Thanks in advance

Satyam,

2 12843

Hi, My source is oracle(eno,ename,sal,commision,...), my requirement is like this, if there is a null values in commission col i want to keep it as null,and for the remaining first two characters of the value in my target. Plz help me

1 2923

Please tell me What is difference between 8.0 and 8.1

IBM,

1 6341

i have flat file and using unix how can i generate sequence number into targer?

Cap Gemini,

1 10066

plz tell me some dimentional and fact table names in banking project?

Virtusa,

2 10076

i have one table with one column in this column i have three rows like 1,1,2 then that rows populate to target as first tow rows as one row and remaing row as one row how it posible? COLUMN_NAME SHIVA RAMU MADHU THEN I WANT TO LIKE SHIVA AND RAMU IN ONE ROW AND MADHU IS ONE ROW IF ANY ONE KNOW PLZ TELL ME

Cap Gemini,

3 10056

How to Convert a string function to date function by using only sequential file stage with out using other stages ?

TCS,

5 22672

source file is having 5 records while moving into target it want to be 10 records

IBM,

4 11437

pls ,tell me good Training centre with Job Oppertunity for Data stage in chennai?

1 4076

I have file with empid,empname and I want to load these two fields along with sal in my target 1)salary must be same for all the records 2)I want pass the salary at run time

TCS,

7 11450

Post New Data Stage Questions

Un-Answered Questions { Data Stage }

How you Implemented SCD Type 1 & Type 2 in your project?

4129

Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.

2293

What are the different common services in datastage?

1284

What are the difference types of stages?

1214

How to reverse the string using unix?

3508

What are constraints and derivations?

1169

How do you start developing a datastage project?

1104

Can you explain kafka connector?

1311

What are the different types of lookups in datastage?

1054

What is job control?

1111

What are datastage sequences?

1118

Difference between server jobs & parallel jobs?

1076

What are the types of jobs we have in datastage?

1075

Is possible to create skid in dim,fact tables?

2636

Name the command line functions to import and export the DS jobs?

1155

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