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

Hi , Can anyone give few examples of scenarios and there corresponding design in datastage..i am new to this tool...confused in design while my manager asking to design the job.. Please post the URL if there..so i can go through it.. Thanks in advance...

UHG,

3259

What is a range lookup?

IBM,

2 5260

what is 'reconsideration error' and how can i respond to this error and how to debug this

Wipro,

1602

there are two schemas x and y are there. some data is in x schema. i want to use that in y schema..how can i use? please give some possibilities

Wipro,

2 5599

How to display all the duplicate records from the oracle Table?

IBM,

3 6957

how can find maximum salary by using Remove duplicate stage?

IBM,

5 10131

what are the types of nodes

HCL, TCS,

3 20726

how to unlock a locked job in datastage 8.0

HCL,

3 19905

WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE

2724

how to remove duplicates in transformer stage by using stage variables?one example?

Syntel, TCS,

6 26460

IS FILE SET CAN SUPPORT I/P AND O/P LINK AT A TIME?

1 3745

how to find out number of records imported into source file?

1 5031

what is a force compile

Cap Gemini, IBM,

2 6324

what is a message handler

IBM,

3 7934

what is the use of invokation id

IBM,

2 8402


Post New Data Stage Questions






Un-Answered Questions { Data Stage }

Explain entity, attribute and relationship in datastage?

147


Differentiate between validated and Compiled in the Datastage?

163


How complex jobs are implemented in datstage to improve performance?

150


In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?

535


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

1178






What is process model?

1042


How to convert RGB Value to Hexadecimal values in datastage?

2929


What is use Array size in datastage

774


If you want to use the same piece of code in different jobs, how will you achieve it?

137


What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?

2120


Explain how a source file is populated?

177


if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables? how can i implement scd typ1 and type2 in both server and in parallel? field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the duplicate rows,inthe fields?

1300


Why do we use exception activity in Datastage?

185


How a source file is populated?

159


What is the difference between validated and compiled in the datastage?

180