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

what is a junk dimension ?

14 Answers   Atos Origin, Cognizant, HS, NIIT, TCS,

---

My questions is i create a two sessions for one mapping.but my requirement is if all number of source records are same as in target then execute first session or some rows are rejected due to t/r logic so session two was execute please clarify

1 Answers   TCS,

---

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

4 Answers   CTS, Sonata,

---

What is workflow? What are the components of the workflow manager?

0 Answers  

---

What is aggregate cache in aggregator transforamtion?

5 Answers  

---

what are the transformations that restricts the partitioning of sessions?

1 Answers  

---

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

2 Answers   Keane India Ltd,

---

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

0 Answers   Informatica,

---

How do you manage the Parameter files while migrating your data from one environment to another environment?

0 Answers  

---

How can you recover the session in sequential batches?

1 Answers  

---

If I have set the property Treat Source Rows as Insert and for the target properties I have checked the boxes Update as Update, what will happen to incoming rows? What exactly is the use of these check boxes and in which scenarios we use them. Also what is the sequence in which informatica understands these properties.Does it takes whatever is defined in treat source rows as property or it is in any other way. Please explain.

3 Answers   Amdocs,

---

supose if ur scr table contains alphanumeric values like 1,2,3,a,v,c in one columen like c1 n now u have load d data in 2 seperare columns like ID should contain only numbers 1,2,3 n NAME col should contain a,b,cin target?How

4 Answers   TCS, Wipro,

---