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 Answers
- 6863 Views
- HCL, I also Faced
- E-Mail Answers
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
Demonstrate experience in maintaining quality process standards?
In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?
Can you explain engine tier in information server?
What could be a data source system?
Explain the importance of surrogate key in data warehousing?
How do you schedule or monitoring the job?
explain about citrix scheduling tool in datastage
State the difference between an operational datastage and a data warehouse?
what is the difference between == and eq in UNIX shell scripting?
what is repositery?
What are the types of containers in datastage?
Whats difference betweeen operational data stage (ods) and data warehouse?
What is the sortmerge collector?
How do you reject records in a transformer?
Where do the datastage jobs get stored?
