Answer / suresh

primary-key:-
It represents one or more fields or attributes that uniquely identified each record in a database table.

surrogate-key:-It is a single part,artificially established identifier an entity,surrogate key assignment is a special case of derived data-one where the primary is derived.A common way that surrogate key values is to assign integer values sequentially.

What are the hard ware required for a normal sized data warehouse? and What are the software required for a normal kind of data warehouse?

2 Answers   CTS,

---

suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?

3 Answers  

---

What is aggregate cache in aggregator transformation?

0 Answers   Informatica,

---

Diff b/w ShortCut and reusabel Object ?

4 Answers  

---

what is data driven in update strategy transformation?

2 Answers   HCL, PayPal,

---

My source is like bellow F.NAME M.NAME L.NAME A B C D E F G H I and out put should like S.NO F.NAME M.NAME L.NAME 1 A B C 2 D E F 3 G H I 4 UNNOWN UNNOWN UNNOWN How can we acheive? please explane me indetail

2 Answers   Amdocs,

---

"Change cache" in Informatica ?

2 Answers  

---

How do you change parameter when you move it from development to production.

1 Answers  

---

What are the issues u have faced in ur project? Guys pls answer to dis question.Due to this question I have failed in 3 interviews.

3 Answers   Amdocs, Deloitte,

---

write sql query following table amount year quarter 1000 2003 first 2000 2003 second 3000 2003 third 4000 2003 fourth 5000 2004 first 6000 2004 second 7000 2004 third 8000 2004 fourth i want the output year q1_amount q2_amount q3_amount q4_amount 2003 1000 2000 3000 4000 2004 5000 6000 7000 8000

1 Answers   HP,

---

Can you generate sequence numbers without using the sequence generator transformation?

0 Answers  

---

What is the internal processes of integration server in Informatica? How data will be extract and load to the target?

0 Answers   TCS,

---