Answer Posted / sudheer

Select ABC.CITY AS CITY, sum(ABC.male) as MALE, sum(ABC.Female) as FEMALE from

(
select city, Sum(no) as male, NULL AS female from table_name
where gender = 'male'
Group by city

UNION

select city, NULL as male, SUM(no) AS female from table_name
where gender = 'female'
Group by city

) ABC Group by CITY

Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance

1999

---

What is data movement mode in Informatica and difference between them?

1119

---

One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?

2251

---

How to generate sequence numbers?

1071

---

What is a dimensional model?

964

---

What is a transaction control transformation?

1181

---

Which files are created during the session rums by informatics server?

1155

---

While importing the relational source definition from the database, what are the metadata of source that will be imported?

1245

---

How to implement security measures using repository manager?

1153

---

COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1

1936

---

my source is junk data how will u remove that junk data by using unix please any one replay me

3686

---

What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?

1061

---

In how many ways we can create ports?

1109

---

Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?

1230

---

COM components can be used in Informatica

2369

---