Answer / guest

Actuvally as a developer we can not no data base size.In
developing we have only dummy records.Client dont give the
original data.And also we didnt involve the production
sopport.

Answer / dheeraj patidar

ur calculate size of data base in oracle



select sum(bytes)/1024/1024 from dba_data_files;

why dimenstion tables are denormalized in nature ?

3 Answers  

---

how can u generate sequence of values in which target has more than 2billion of records.(but with sequence generator u can generate upto 2 biliion only)

6 Answers   Accenture,

---

in realtime which situations u can use unconnected lookup transformation

2 Answers   Patni,

---

without table how to come first record only in oracle?

0 Answers  

---

Hi experts ,I have a Source of 1000 records.I have to load 100 records in first target,101 to 200 records in 2nd target, 201 to 300 records in 3rd target and again 301 to 400 in first target like that as cyclick process. How can i acheive this.

5 Answers   DELL, TCS,

---

---

How or for what purpose look up transformation would be useful in Sales or Banking Project? Please reply!

2 Answers  

---

what is parallel querying and what r hints.

1 Answers  

---

My Source qualifier has empno, sal. Now my mapping is like SQ(EMPNO)->AGGR->EXP->TARGET SAL ------------>TARGET ? Is this mapping valid or any issues are there if we design like this?

3 Answers   Span Systems,

---

What is the term PIPELINE in informatica ?

7 Answers   Deloitte,

---

Could any one to tell Fact table Partitioning?

2 Answers  

---

How to fix the etl bugs..Tell me the process?

1 Answers   IBM,

---

Explain the features of connected and unconnected lookup.

0 Answers  

---