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

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

how to abort the job its matain duplicates?

2112


What is process model?

1558


What are the components of ascential data stage?

656


How to find value from a column in a dataset?

1771


What is aggtorec restructure operator?

731






Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?

1766


What could be a data source system?

581


What is use Array size in datastage

1313


What is difference between join, merge and lookup stage?

642


What are the difference types of stages?

627


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

1755


What are the different plug-ins stages used in your projects?

630


Difference between in process and inter process?

704


A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?

2037


How to convert RGB Value to Hexadecimal values in datastage?

3463