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...


1.what is stagearea?what is stage variable?
2.this is my source
source:id, name target:id, name
100, murty 100,madan

we have three duplicate records for the id column,how can we getthe source record?
100,madan
100,saran



1.what is stagearea?what is stage variable? 2.this is my source source:id, name target:id, name ..

Answer / lokesh

stage area is temporary memory location in real time
environment we get the data in form of files from client so
we need to store one temporary memory location and perform a
all validations like data validations and filed validation
and file validations . ofter we lode into a warehouse


stage variable assinge the expression in transformerstage
that can be reusable only with in transformerstage only
so it is called the stage variable

i am taking key column as name so we get the source record

Is This Answer Correct ?    2 Yes 2 No

Post New Answer

More Data Stage Interview Questions

detail about sdlc

4 Answers  


what is the difference between 7.1,7.5.2,8.1 versions in datastage?

3 Answers   IBM,


i have source like deptno,sal 1,2000 2,3000 3,4000 1,2300 4,5000 5,1100 i want target like target1 deptno,sal 1,2000 3,4000 4,5000 target2 2,3000 1,2300 5,1100 with out using transformerstage

6 Answers  


job locking methods? How can we unlock the job?

3 Answers   IBM,


what is flow of project?

0 Answers   HSBC, IBM,


How many types of hash files are there?

0 Answers  


Difference between server jobs & parallel jobs?

0 Answers  


1)What is configuration your file structure 2)I have two databases both are Oracle while loading data from source to target the job takes 30 min but I want to load less time how?

1 Answers   Hexaware,


How to implement complex jobs in data stage?

0 Answers  


Please tell me What is difference between 8.0 and 8.1

1 Answers   IBM,


What are the types of views in datastage director?

0 Answers  


What are the different database update actions available?

1 Answers   HP,


Categories