How to generate surrogate key without using surrogate key stage?
Answer Posted / murali
yes ur right but we have another way to generate s key by
using transformer .in transformer we have a surrogate key tab
click the skey tab in that we hav state file and db sequence
these r used for generate and hold the s key value
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
EXPLAIN SCD
How do u convert the columns to rows in datastage?
How a server job can be converted to a parallel job?
What are the repository tables in datastage?
Explain the datastage parallel extender (px) or enterprise edition (ee)?
How the ipc stage work?
What are the functionalities of link partitioner and link collector?
What are the different type of jobs in datastage?
Differentiate between Join, Merge and Lookup stage?
What is process model?
What can we do with datastage director?
To see hidden files in LINIX?
how to delete one row in target dataset
Can anyone tell me a difficult situation who have handled while creating Datastage jobs?
Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.