Interested to Buy Any Domain ? << Click Here >> for more details...
how can we create a Sorrogate key in transformer stage? I
want it in parallel mode
- 2 Answers
- 12898 Views
- Syntel, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / varma
In transformer Properties, there is a tab called “Surrogate Key”. Here we can define it.
We can select from
a. Flat file : State file which holds the SK values and generates SK values.
b. DB Sequence: Database sequence object to use to generate the SK values.
| Is This Answer Correct ? | 11 Yes | 2 No |
When we will go for Data elements?
Hi every one, I am Suneel. I/p o/p --- ----- suneel suneel suneel suneel suneel suneel how it will get. Please design job with explain. Thanks.
convert yyyy mm dd to dd mm yyyy?
Source Like department_no, employee_name ---------------------------- 20, R 10, A 10, D 20, P 10, B 10, C 20, Q 20, S and Output should be like this department_no, employee_list -------------------------------- 10, A 10, A,B 10, A,B,C 10, A,B,C,D 20, A,B,C,D,P 20, A,B,C,D,P,Q 20, A,B,C,D,P,Q,R 20, A,B,C,D,P,Q,R,S
1.what is materialized data? 2.how to view the materialized data?
What are the types of views in datastage director?
Input Data is: Emp_Id, EmpInd 100, 0 100, 0 100, 0 101, 1 101, 1 102, 0 102, 0 102, 1 103, 1 103, 1 I want Output 100, 0 100, 0 100, 0 101, 1 101, 1 Means Indicator should either all ZEROs or all ONEs per EmpId. Impliment this using SQL and DataStage both.
how to create document in datastage?
how many types of remove the duplicate records?
What is ibm datastage?
how to find no.of records in sequntial file itself?
Why we need datasets ratherthan sequential files?
Teradata 
