Answer / suresh

surrogate key is alternate to primary key,it allows duplicates also,while maintain the hystorical data we use surrogate key

Answer / prabhu rathnam

Surrogate key is used to generate sequence of number from 1 to n. It increment by 1 continously and sequencly.

Answer / siva katta

"Surrogate key" which is system generated unique numeric values.

uses:
---------
when implimenting the SCD2 $SCD3. because these scd's are needs to maintain the historical information. so there is no way to maintain the historical information with Primary key constraint,so we are gonna generate the Surrogate key for identifying the records need to take the insert or update action.

Note :
------
Surrogate key we can use for many purpose and so many cases but the above usage is one of these.

Answer / karan am

surrogate key is alternate to primary key, in order to maintain historical data.

The key source can be a state file or a database sequence. If you are using a database sequence, the sequence must be created by the Surrogate Key stage. You cannot use a sequence previously created outside of DataStage.

Answer / mohanasam

pls example

4) source target c1 c1 c2 c3 c2 c4 c4 c5 c3 c6 c7 c4 c5 c6 c7 please send me answer this question my mail

1 Answers  

How to use Environment variable's in datastage?(use of process)

1 Answers   CSC,

What is a range lookup?

2 Answers   IBM,

how to do pergformence tuning in datastage?

4 Answers   MCA, Symphony, TCS,

can explain wt is the pool for file.

1 Answers   CTS,

project Steps,hits, Project level HArd things,Solved methods?

0 Answers   Hexaware,

Have you have ever worked in unix environment and why it is useful in datastage?

0 Answers  

in sequtial file 2 columns avaliable, i want only one column load the target. for this we can do by modify and copy stage. But here when using modify stage (in property drop column1) until it is ok. if target is data set How to view the data. with out using data management. what is the reason for this. if any body know this answer plz tel me. thanks.

1 Answers   IBM,

Hi I have scenario like this s/r table T/r table ename,sal empno,ename,sal vijay,2000 1 , vijay, 2000 kumar,3000 2 ,kumar , 3000 ravi ,4000 3 ,ravi , 4000 How can i get target table like that without using Transformer stage?

8 Answers   Semantic Space,

Differentiate between operational datastage (ods) and data warehouse?

0 Answers  

A table containg 100 records B table containg 20 records we have to join two tables in left outer it containg target 100 records but target containg 101 record at that time what is the issue arise

3 Answers   Polaris,

what is materialized view used datastage?

1 Answers   HSBC,