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 / 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 |
how to find no.of records in sequntial file itself?
parallel jobs run on cluster machines. server jobs run on smp and mpp. What do mean by cluster mechines and SMP and MPP..?
Please explain me the difference between 3 types of slowly changing dimension in datawarehousing?
What is lookup table?
What is the use of datastage designer?
EXPLAIN SCD
Give example for FACTLESS FACT TABLE in real-time scenario.
which is the most complex job in your career? Please tell me answer?
Why we use parameters instead of hard code in datastage.
What's the Main Function of the Staging area in DWH
why we use parameters instead of hard code in datastage
How many nodes supported by a one cpu in parallel jobs?