Interested to Buy Any Domain ? << Click Here >> for more details...
How to generate surrogate key without using surrogate key stage?
- 6 Answers
- 30812 Views
- IBM, I also Faced
- E-Mail Answers
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
State the difference between an operational datastage and a data warehouse?
How to read the length of word in unix?
DB2 connector> transformer > sequential file Data will be exported into a csv format in a sequential file. This file will be send in a email using a sequence job. Problem here is, how to avoid sending a blank csv file? When I ran the job there are chances that it might return zero records but in the sequence job csv file is going blank. how can I avoid this? thanks
How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?
In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?
Differentiate between hash file and sequential file?
Nls stands for what in datastage?
What is the difference between the local container and shared container?
what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?
What are the repository tables in datastage?
Could anyone give brief explanation bout datastage admin
1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)
What all are the different way to run a job?
What are the different layers in the information server architecture?
In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?
