Answer / sunil

)At DB level we can simply DROP the stagin table.
2)then Create Target table at DB level.
3) Directly LOAD the records into target table.

NOTE: It is recommended to use staging area

Please explain in detail with example about 1.Confirmed Dimension. 2.Junk Dimension. 3.Degenerated Dimension. 4.Slowly changing Dimensions

3 Answers   Infotech,

---

What are the join types in joiner transformation?

1 Answers   Informatica,

---

What is a candidate key?

7 Answers   CTS,

---

i have flat file it contains 'n' number of records, i need to send half of the records to one target table and Remaining half to another target table. can any tell me procedure.

2 Answers   TCS,

---

What do you understand by a term domain?

0 Answers  

---

Write the different tools in the workflow manager?

0 Answers  

---

2,can we insert duplicate data with dynamic look up cache,if yes than why and if no why?

2 Answers   TCS,

---

What is the difference between the system variables $$$SessStartTime and SESSSTARTTIME?

2 Answers  

---

Dimension Object created in Oracle can be imported in Designer Cubes contain measures

0 Answers  

---

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

0 Answers   HP,

---

What is sequence generator transformation in informatica?

0 Answers  

---

lookup is passive y can't it be active? let us say i have some records in my source like 101,rohit,1000 101,rohit,1000 102,kumar,2000 like wise now as it is having multiple matches i return only first,last value it can't return bouth the values that means lookup is acting as select distinct right by default what means it is active?

5 Answers   IBM,

---