Answer / niranjana

Datawarehouse objects are Dimension tables,Fact tables,Unique identifiers and relationships

Answer / manju

Sources, Targets, Mappings, Mapplets, sessions, workflows,
worklets, tables, views, sequences,procedures, cursors... are
objects part of data warehouse.

how many ways can we implement SCD2?

4 Answers   IBM, TCS,

---

How do you load unique records into one target table and duplicate records into a different target table?

0 Answers  

---

How can one know that a table has indexes and is partitioned? How data will be pulled from Partitions in Oracle for Informatica?

1 Answers  

---

I have the input file as col1 col2 col3 3 2 1 7 6 8 I should get the output as col1 col2 col3 1 2 3 6 7 8 ....What is the logic to get this? Is there any transformation which sorts row wise ? If not how to sort the incoming records row wise?

5 Answers  

---

Hello all, In SOA architecture i.e 8.6 , What is mean by node exactly?

4 Answers  

---

In which situation we will use persistant cache and shared cache in real time. plzsss answer with example

1 Answers   Wipro,

---

I have a scenario which load the data frm single source to 2 targets as T1, T2, and T1 have a P.K and T2 have F.K relations. first data has to load in T2, and then data load to T1 if that record exist in T1... how can we acheive it?

2 Answers   Ness Technologies,

---

i having mapping emp---> sq_emp--->target using this mapping i have to load dept table values into target... (condition assume there is no primary and foreign key relation between emp(table x) and dept (table Y))

5 Answers   Cap Gemini,

---

what is the location of parameter file in informatica?

1 Answers   TCS,

---

What is an aggregator transformation? it is active why cant it be passive explain?

3 Answers   HCL,

---

Major difference between SQL override and Lookup Sql override

1 Answers  

---

Do you have knowledge in ralph kimball methodology

1 Answers  

---