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
- 7472 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 |
Which algorithm you used for your hashfile?
what is main difference between change capture and change apply stages
What is a range lookup?
what is snow flack schema?
souce file having the columns like name company krish IBM pooja TCS nandini WIPRO krish IBM pooja TCS if first row will be repeat i want the result like this name company count krish IBM 1 pooja TCS 1 nandini WIPRO 1 krish IBM 2 pooja TCS 2
Thanks to all people who are posting their comments...
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
What is diff between Junk dimensions and conform dimension?
If there is a file that contains 1000 records, I need the ouput to contain these 1000 records with the header as file name concatenated with the current timestamp and trailer as the count of records
how to find diff between 2 dates without using Icon... funtions?
what is the use of surogate key in datastage
What are the different database update actions available?
Teradata 
