Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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,

4137

What is a range lookup?

IBM,

2 7619

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

Wipro,

2555

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 8081

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

IBM,

3 9932

how can find maximum salary by using Remove duplicate stage?

IBM,

5 14450

what are the types of nodes

HCL, TCS,

4 25365

how to unlock a locked job in datastage 8.0

HCL,

3 23171

WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE

3607

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

Syntel, TCS,

6 33339

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

1 5406

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

1 6714

what is a force compile

Cap Gemini, IBM,

2 9016

what is a message handler

IBM,

3 10662

what is the use of invokation id

IBM,

2 10801


Post New Data Stage Questions

Un-Answered Questions { Data Stage }

1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?

2209


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.

3968


What is difference between server jobs & parallel jobs?

986


Explaine the implimentation of scd's in ds indetail, please send me step by step procedure to perform scd's 1,2,3. Please replay for this, Thanks in advance

2166


Can you define merge?

1063


Have you used Unstructured data?

1267


What are sequencers?

1057


What are routines in datastage?

1265


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

2196


What are the functionalities of link partitioner and link collector?

950


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

1029


What is apt_config in datastage?

1082


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

1045


What is merge stage?

1225


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

3076