Answer / srinivas

Both the files are used for look up purpose but Hash file is in server edition and witch we don't have in parallel edition.


Same Look up file also existed in parallel not in server edition.

In both files we have to give the key column.

What is Fastly Changing Dimension?

6 Answers   TCS,

---

Explain Quality stage?

1 Answers  

---

How can we do null handling in sequential files

3 Answers   Reliance,

---

Please explain me the difference between 3 types of slowly changing dimension in datawarehousing?

3 Answers   TCS,

---

why do u need the IOS upgradation in a FC switch

1 Answers   IBM,

---

What are some prerequisites for datastage?

1 Answers  

---

source file is having 5 records while moving into target it want to be 10 records

4 Answers   IBM,

---

How to transfer file from one system to another system in UNIX?which command to be use?

4 Answers   Cap Gemini, TCS,

---

if the source file is CID,CCODE,CONNDATE,CREATEDBY 0000000224,1000,20060601,CURA 0000000224,2000,20050517,AFGA 0000000224,3000,20080601,TUNE 0000000225,1000,20020601,CURA 0000000225,2000,20050617,AFGA 0000000225,3000,20080601,TONE AND TARGET is oracle following are the validations cid loaded with unique records leading zeors has to be deleted while loading cid in target load only customer who got early connected to company conn_date should be loaded into oracle date format cid datatype is varchar2 in target conn_date is data datatype ccode is varchar2 0000000224,1000,20060601,CURA 0000000224,1000,20060601,CURA

2 Answers  

---

What is the surrogate key? what is the use of surrogate key? how to Create surrogate key Generator in scd2 in 8.5?

5 Answers   SLK Software,

---

Explain the scenarios where sequential file stage runs in parallel?

3 Answers   Accenture,

---

Which warehouse using in your datawarehouse

1 Answers   IBM,

---