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

how to find no.of records in sequntial file itself?

4 Answers  


parallel jobs run on cluster machines. server jobs run on smp and mpp. What do mean by cluster mechines and SMP and MPP..?

3 Answers  


Please explain me the difference between 3 types of slowly changing dimension in datawarehousing?

3 Answers   TCS,


What is lookup table?

5 Answers  


What is the use of datastage designer?

0 Answers  


EXPLAIN SCD

0 Answers   CTS,


Give example for FACTLESS FACT TABLE in real-time scenario.

4 Answers   TCS,


which is the most complex job in your career? Please tell me answer?

2 Answers   IBM, Wipro,


Why we use parameters instead of hard code in datastage.

2 Answers   IBM,


What's the Main Function of the Staging area in DWH

3 Answers   Oracle,


why we use parameters instead of hard code in datastage

4 Answers   HCL,


How many nodes supported by a one cpu in parallel jobs?

3 Answers   IBM,


Categories