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 |
what r the stages mostly used in realtime scenarios
What is a delta record? How you will read it?
Why we use surrogate key?
I have scenario like this seq file --> transformer --> sort stage --> dataset In this job which prtitioning technique you are using and why???
Explain connectivity between datastage with datasources?
In Datastage, how you can fix the truncated data error?
A job is having only 2 stages I/p dataset and target table.Job is taking very long time to load 50 million records.How to improve performance of this job.
In which situations we can use normal and sparse lookup stages
pls ,tell me good Training centre with Job Oppertunity for Data stage in chennai?
WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE
what is a message handler
What are the types of jobs we have in datastage?