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

can any one tell me how to install datastage 8.1 in windows xp with wizard

2 Answers  


What is the use of Row generator stage?

2 Answers  


In Informatica,for the table I can find coreesponding dependent mappings.Likewise can I find the dependent jobs with all the information by using the table name

0 Answers   TCS,


Why we use surrogate key?

0 Answers  


How to add zero "0" before record in a field?

4 Answers  






How do y read Sequential file from job control?

2 Answers   HP, IBM, Telesis,


I have a input as: Col 1 1 2 2 3 I want 3 output as: Output1: 1 1 Output2: 2 2 Output3: 3 i.e. same duplicates should be in one target, other duplicate values should be in another target and so on.. Pls help

9 Answers   IBM,


How many partitions does a node can have? Some body explain me clearly about the partitions and the nodes?

3 Answers  


what is push and pull technique??? I want to two seq files using push technique import in my desktop what i will do????

1 Answers   TCS,


How can we improve the performance in datastage?

0 Answers  


options available in sequence job to run,validate?

0 Answers   CTS,


How to manage date conversion in Datastage?

0 Answers  


Categories