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
what is the use of surogate key in datastage
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
What is the roundrobin collector?
What is job control?
how to sort two columns in single job in datastage.
How can one find bugs in job sequence?
What are the types of containers?
How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.
How many types of hash files are there?
How to perform incremental load in datastage?
What is the difference between Datastage 7.5 and 7.0?
Where the datastage stored his repository?
what is the difference between == and eq in UNIX shell scripting?
What are the areas of application?
What are the benefits of datastage?