Interested to Buy Any Domain ? << Click Here >> for more details...
what is the main difference between sorragate key n primary
key in one word
- 2 Answers
- 11386 Views
- I also Faced
- E-Mail Answers
Answer Posted / nagaraz
surrogate key is an artificial identyfier for an entity.in
surrogate key are generated by the system sequentially.
primary key is a natural identifier for an entity.in
primary key are all the values are enterd manually by the
which are uniquely identifier there will be no repetion of
data
| Is This Answer Correct ? | 10 Yes | 0 No |
Post New Answer View All Answers
Explain usage analysis in datastage?
8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?
disign the complex job in u r project?(they are aksing only complex job design and then data flow...)
How to create a file using vi editor? 2)how to delete a file in vi editor? 3)How to connect the server datastage to unix? what r the command lines we r using? 4)30 jobs r runnig in unix i want to find out my job. how to do this? give me command?
how to sort two columns in single job in datastage.
Distinguish between informatica & datastage. Which one would you choose and why?
1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?
Have you have ever worked in unix environment and why it is useful in datastage?
Nls stands for what in datastage?
if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?
What is a datastage job?
What is apt_config in datastage?
What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)
how to abort the job its matain duplicates?
how to export or import the jobs in .ISX file
