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,

---

to improve the performance of aggregator we use sorted input option and use sorter t/r befor aggregator. But here we are increasing one more cache in our mapping i.e; sorter. So how can u convince that you are increasing the performance.?

3 Answers   IBM,

---

What is a dimensional model?

0 Answers  

---

what is difference between mapping and mapplet ?

2 Answers   TCS,

---

As union transformation gives UNION ALL output, how you will get the UNION output?

0 Answers   Informatica,

---

---

How do you change parameter when you move it from development to production.

1 Answers  

---

Performance tuning( what you did in performance tuning)

0 Answers   Infosys,

---

Hi Experts, Performance Wise Which transformation is better in LOOKUP AND JOINER TRansformations? Why? Can anybody please explain it ? Please help me out from this Question. Thanks In Advance.

2 Answers   CTS,

---

what are surrogate keys?

5 Answers  

---

Hi All, I've 110 records in my table but 101 records contains an error. When I run the session, I want to load the 100 records into the target. Can anyone suggest me the best solution for this... Thanks in Advance,

7 Answers   Tech Mahindra,

---

What is the difference between Power Centre and Power Mart?

5 Answers   TCS,

---

What are the unsupported repository objects for a mapplet?

1 Answers   Informatica,

---