how can we create a Sorrogate key in transformer stage? I
want it in parallel mode
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 |
what are the types of nodes
A flat file contains 200 records. I want to load first 50 records at first time running the job, second 50 records at second time running and so on, how u can develop this job?
Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?
source file is having 5 records while moving into target it want to be 10 records
How to lode data in sequntional files perform faster?
How do you import and export data into datastage?
Scenario : I have 2 jobs say job A and Job B with parameters x and y respectively. I need to create a sequence job. If we pass parameter x then Job A should run, If we pass parameter y then Job B should run, if we dont pass any parameter then Both Job A & B should run.
What is the purpose of pivot stage and types of containers in datastage
what is use of SDR function?
3) Sequential file contains data like Empno ename sal 111 abc 2000 Trgt file: Trgt1----111 Trgt2----abc Trgt3---2000
what is difference between migration project and integration project? can anyone explain with the example Thanks in advance
how many dimentions and fact tables used in your project and what are names of it?