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;

I have 1 crore record in my table and I have to load 25 L in 1st target,25L in 2nd target and 25L in 3rd target? I am new to Informatica,can anybody suggest me the idea?

2 Answers  

---

hi all, Can anyone please tell me the relationship between informatica and business objects

1 Answers  

---

What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?

2 Answers   TCS,

---

What r the type of indexes u generally used in informatica?

2 Answers   Keane India Ltd,

---

Any one can tell me how to explain puss-down optimization ? explain me with example plz?

1 Answers  

---

Write the program through which the records can be updated?

0 Answers  

---

when do we use static cache and when do we use dynamic cache in lookup transformation? with example.

1 Answers  

---

1)can anyone explain how to use Normalizer transformation for the following scenario Source table | Target Table | Std_name ENG MAT ART | Subject Ramesh Himesh Mahesh Ramesh 68 82 78 | ENG 68 73 81 Himesh 73 87 89 | MAT 82 87 79 Mahesh 81 79 64 | ART 78 89 64 | please explain what should be the normalizer column(s) The GCID column 2)Also please explain the Ni-or-1 rule.

5 Answers   FCS, IBM, Satyam, TCS,

---

difference between stop and abort

2 Answers  

---

write sql query following table quarter sales q1 1000 q1 2000 q1 3000 q1 4000 q2 5000 q2 6000 q2 7000 q2 8000 q3 1000 q3 2000 q3 3000 q3 4000 q4 5000 q4 6000 q4 7000 q4 8000 i want the output format like q1 q2 q3 q4 1000 5000 1000 5000 2000 6000 2000 6000 3000 7000 3000 7000 4000 8000 4000 8000

5 Answers   CTS,

---

how the data will be loaded while desiging the schema?which one first (for e.g.-dimesions and facts)

2 Answers   Sonata,

---

If we are using an aggregator but forget to mention the group by port .what will be the output??

11 Answers   Nomura, TCS,

---