Answer / santhosh

sql override is used to write sql select statements
sql override contains in source qualifier transformation

we can use sql override when the source and target are
homogenious database
it will not support flatfiles and hedrogenious database

suppose we have 1 to 10 records.In router transformation we had given two condition A>= 5 A<=5 then what will be the output?

2 Answers   emc2,

---

How can you validate all mappings in the repository simultaneously?

0 Answers  

---

if we have a delimiters at unwanted places in a flat file how can we over come those.

0 Answers  

---

How to list Top 10 salary, without using Rank Transmission?

16 Answers   Infosys,

---

I have a source file its is CSV(comma separated). I want to convert it to tab separated. Make sure the conversion happens on all commas except the ones enclosed in Double quotes .

2 Answers   CTS,

---

Is stop and abort are same in informatica?

0 Answers  

---

I am Unable to load the FixedWith FlatFile Into The Target.What Is The Reason. PLZ Help Me..

1 Answers  

---

Describe expression transformation?

0 Answers  

---

Design a mapping to calculate department wise sum of salaries and load it in single target? Source Target Deptno Salary Deptno Salary 10 100 10 600 10 200 10 600 10 300 10 600 20 200 20 800 20 300 20 800 20 300 20 800 30 400 20 1500 30 500 30 1500 30 600 30 1500

0 Answers   Cap Gemini,

---

Find a way to implement the following logic : You have column like : Column 1 AA|BB|CC DD|EE|FF WW|AA I need to get the length of the column without the ‘|’ .

5 Answers  

---

create a mapping to retrieve the employees who are getting salary greater than average salary?

4 Answers   TCS,

---

What is the approximate size of data warehouse?

6 Answers   Accenture, i3 Solutions,

---