Answer / pr

The default join is inner join. But we can override it by using the SQL overide query and can perform any joins

surrogate keys usage in Oracle and Informatica?

5 Answers   ITC Infotech, Oracle,

---

In SCD type 2 if we had select date range. then suppose we had inserted today's date(eq. date is 30 aug 2010) then start date will be today's date(30 aug 2010) what will be the end date,we cant leave it blank?

2 Answers   Cognizant, emc2,

---

Where is metadata stored?

0 Answers  

---

Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?

0 Answers  

---

write asql query to filter improper date format? date 20-apr 11-mar-2010 30-may-2010 feb-2009 i want the output date 11-mar-2010 30-may-2010

2 Answers   Accenture,

---

any one can informatica metirial to me ple forwrd to my mail id; gbalireddy@gmail.com

1 Answers  

---

whether Sequence generater T/r uses Caches? then what type of Cache it is

7 Answers   Accenture,

---

Describe data concatenation?

0 Answers  

---

Explain lookup transformation in informatica

0 Answers   Informatica,

---

why union transformation is active transformation?

6 Answers   IndiGo, TCS,

---

if we have certain records,if i need to get 5 th rec for the first time to the target,when i run it for next time,i need to get 6th rec...like that it should process.what wil be the procedure to achieve it??

1 Answers   IBM,

---

What is fact table? Explain the different kinds of facts.

0 Answers  

---