Answer / sai suresh

surrogate key is an artificial key , it will generate
automatinclly in sequence it will act as a primary key when
the data is heighly denormalized.

Answer / shiva

surrogate key is a artificial key or system generated
key.when ever a primary key violation occurs,by using
sequence generator t/m we generate surrogate keys

Answer / reddy

surrgate key is not used for the bussiness

Answer / deepthi pathuri

A surrogate key in a data warehouse is more than just a
substitute for a natural key.

(OR)

A surrogate key is frequently a sequential number (e.g. a
Sybase "identity column") but doesn't have to be. Having
the key independent of all other columns insulates the
database relationships from changes in data values or
database design and guarantees uniqueness.

Answer / pradeep

surrogate key is an autogenerated sequence in data warehouse
acts as primary key as the data in warehouse is highly
denormalised form.

I have one source table and three target tables. When the session runs for the first time involving the mapping,i want that the loading should take place in 1st Target table only. The 2nd time the same session runs the loading should take place in 2nd Target only only and similarly when the session runs for the 3rd time loading should take place in Third only. And again when the session runs for the 4th time loading should take place in 1st Target table.

4 Answers   Cap Gemini, IBM,

If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?

0 Answers  

write a query following source region sales 1 1000 2 2000 i want the output ?please give solution 1 2 1000 2000

8 Answers   TCS,

Hi ETL gurus can any one tell me with a flow how to implement SCD Type 1 and SCD Type 2 in a single mapping.For some fields SCD type has to be implemented and for some fields scd type has to be implementd..Thank in advance..please let me know in case of any concerns...

1 Answers  

Repository user profiles

0 Answers  

how can we convert a column into row in informatica? Eg: INPUT- a x Output Like: a b c b y x y z c z

3 Answers   CTS,

Why the workflow is failed after running two hours in informatica?

1 Answers   GE,

what is distinct

4 Answers  

What is the difference between router and filter?

0 Answers  

i have source as Column1 101 a 101 b 101 c so i want to load target as column1 ---> 101 abc

3 Answers   HP,

If u select groupby port in aggregator what is output and dont select groupby option what is output

2 Answers  

can anyone suggest best free Talend data integration training online

0 Answers