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 you can fix the truncated data error in datastage?

1207


What is a quality stage in datastage tool?

632


What is the difference between operational data stage (ods) and data warehouse?

675


What is merge stage?

767


Explain the situation where you have applied SCD in your project?

1562






What is process model?

1553


What is the difference between informatica and datastage?

658


What is the roundrobin collector?

641


Triggers,VIEW,Procedures

802


Can you explain kafka connector?

777


What a datastage macro?

638


What is the process of killing a job in datastage?

593


Differentiate between datastage and informatica?

727


how to use self join using datastage ? can u tell me using stage how can we implemnet the self join

4569


Define repository tables in datastage?

704