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.

Answer / kiran

There is a surrogate key option in transformer.

What is the command line function to import and export the ds jobs?

0 Answers  

---

How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?

0 Answers   Reliance,

---

Tell me Wt main advantage of Stage varibles? Project level hints?

4 Answers   Hexaware,

---

how many rows sorted in sort stage by default in server jobs

0 Answers   Syntel,

---

what is the use of surogate key in datastage

0 Answers   TCS,

---

what is difference between migration project and integration project? can anyone explain with the example Thanks in advance

2 Answers   Satyam,

---

Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.

0 Answers  

---

SEQUENTIAL FILE I HAVE ONE RECORD,I WANT 100 RECORDS IN TARGET?HOW CAN WE DO THAT?PLS EXPLAIN ME AND WHAT STAGES ARE THERE?WHAT LOGIC?

1 Answers   TCS,

---

how to unlock a locked job in datastage 8.0

3 Answers   HCL,

---

explain unit testing,systemtesting,integrated testing

1 Answers   CSC,

---

Terminate Activity

0 Answers   CTS,

---

how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)

0 Answers  

---