Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 7231 Views
- HCL, I also Faced
- E-Mail Answers
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 |
I have a few records just I want to store data in to targets cycling way how?
DataStage Scenario based Interview Questions
Can we use sequential file as source to hash file? Have you do it ?if what error it will give?
what is stage is used for below Input columns: dept|mgr|employee|salary Output columns: mgr|count of employee per mgr|avg salary per dept note: each dept has one mgr and each mgr has many employees
Hi This is Vijay How Can u Read the data from sequential file Parall'y?
What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?
Which type of joins Merge stage can support?
Difference between server jobs & parallel jobs?
how many types of remove the duplicate records?
on how many columns we can perform aggregation in the Aggregator stage?
i have a scenario like two columns(Empno, Ename) in that duplicate records are there, so my question is how to get second duplicate record in datastage.
What are the different database update actions available?
Teradata 
