Answer / srinivas

if source is table you can use sql override
select * from emp
union
select * from emp
and if source is not a table run the session twice

Answer / sbvp

RUN THAT MAPPING TWICE U WILL GET 20 RECORDS

Answer / guduri

to get dis dont enable the property called truncate target
table option in session properties

How to Explain My project flow,In TCS ased me this question. In which way i can start my project flow and they asked how many fact tables and dimensional tables u used. Can any one Explain Briefly for this question and project architecture also.. please..

3 Answers   CTS, HCL, Infosys, TCS,

---

My source table having some records ,i want load 1st record and last record into one target?

3 Answers   iGate,

---

How many dimensions are there in informatica?

0 Answers  

---

what are the different types of transformation available in informatica. And what are the mostly used ones among them?

0 Answers  

---

Whether Aggrigator transformation ignore the null values or consider the null values ? Advance Thanks, Manojkumar

3 Answers   IBM,

---

what is meant by data driven.. in which scenario we use that..?

2 Answers   IBM,

---

what is the necessity to use update strategy?(except for updates)

2 Answers   Emphasis,

---

What are reusable transformations in how many ways we can create them?

2 Answers  

---

Define Update Override?

1 Answers  

---

If the values in a row are 1,2,3,3,4,,4,5 then how a rank transformation can rank these values

6 Answers   TCS,

---

Hi, What is version control in Informatia ? Can anyone just give an idea or introduction about this? Advance Thanks

2 Answers   IBM,

---

Explain scd type 3 through mapping.

0 Answers  

---