Answer / sarvesh

by using the load manager

can u explain me banking domain projects ? and in banking domain projects how many dimension tables and how many fact tables and how to load source and targets in mapping level plese expain give me one example?

1 Answers   Accenture, Cognizant, HCL, IBM, iGate, L&T, TCS, Virtusa,

---

Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,

0 Answers   HCL,

---

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

11 Answers   Nomura, TCS,

---

write a query to retrieve the latest records from the table sorted by version(scd)

0 Answers   Informatica,

---

S1 is having 1 lakh records and s2 is having 100 records, s2 should compare s1 if emp no is same data should be updated if not their it should insert the data.what are the transformation used?

5 Answers   TCS,

---

---

how can one come to know wether the records loak into the target if we use update strategy

1 Answers   Wipro,

---

Is snow flake or star schema used? If star schema means why?

4 Answers   CTS, Sonata,

---

What is a code page?

0 Answers  

---

What is an aggregator transformation?

0 Answers  

---

why dimenstion tables are denormalized in nature ?

3 Answers  

---

what is the size of u r source(like file or table)?

0 Answers   HP,

---

Have you worked with/created Parameter file

0 Answers  

---