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 command line function to import and export the ds jobs?
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?
Differentiate between datastage and datastage tx?
What is the difference between validated and compiled in the datastage?
Can you explain how could anyone drop the index before loading the data in target in datastage?
What are stage variables?
Have you have ever worked in unix environment and why it is useful in datastage?
What are iconv and oconv?
What are routines in datastage? Enlist various types of routines.
How to reverse the string using unix?
State the difference between an operational datastage and a data warehouse?
which r the connectors used in san?
Define APT_CONFIG in Datastage?
What is oci?
Can you explain kafka connector?