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
- 12788 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 |
How can we run same job in 1 day 2 times
1.what is stagearea?what is stage variable? 2.this is my source source:id, name target:id, name 100, murty 100,madan we have three duplicate records for the id column,how can we getthe source record? 100,madan 100,saran
what is factless fact table?
I have a file it contain 2 records like empname,company as Ram, Tcs and Ram, IBM. But i want empname, company1,company2 as Ram, TCS,IBM in the target. How?
how to clear the source file? 2) diff b/t odbc & Oracle?what is node? 3) explain one complex job u face in ur project
how to delete one row in target dataset
hi, how would i run job1 then job 3 , then job2 in a sequence of job1 ,job2,job3. Thanks sunitha
Can aggregator and transformer stages use to sort the data? How ?
What is the Main difference between Lookup Failure and Lookup Not Met? Plz explain with Example.
Hi All, Could you please let me know whether Datastage server and px supports oredb? OREDB:It's a Oracle Retail Embedded Database.Previousely It was called as Acumate data base. It's a multidimensional database. Please help me on this issue ASAP. Thanks in advance Ashok
How to convert RGB Value to Hexadecimal values in datastage?
What are the steps required to kill the job in Datastage?
Teradata 
