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 datastage architecture?
Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?
What is difference between server jobs & parallel jobs?
Name the different sorting methods in datastage.
How do you remove duplicate values in datastage?
what are the devoleper roles in real time? plz tell i am new to datastage....
What are routines in datastage?
What are some prerequisites for datastage?
Hi guys, Please design a job for dis requirement with derivation(solution). my source table like dis. emp_no qualification 1 a 1 c 2 a 3 c 3 b To loaded to target like dis emp_no qualification 1 b 2 b 2 c 3 a my requirement is every employer have three qualifications i.e a,b and c. what qualification missed in source table that will be move to target systems. Hope u got it the requirement. Right Thanks.
Differentiate between datastage and informatica?
Explain the datastage parallel extender (px) or enterprise edition (ee)?
file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4
Name the third party tools that can be used in datastage?
What is the importance of the exception activity in datastage?
To see hidden files in LINIX?