Answer Posted / jay

Override SQL in source qualifies with bellow query

Select Top 5 EmpNo, DeptNo, Sal from Employee where DeptNo = 10 order by Sal desc

Union All

Select Top 5 EmpNo, DeptNo, Sal from Employee where DeptNo = 20 order by Sal desc


Union All

Select Top 5 EmpNo, DeptNo, Sal from Employee where DeptNo = 20 order by Sal desc

What is a sorter transformation?

1102

---

If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?

1497

---

What are the tasks that can be performed using sq?

1092

---

What are the advantages of using informatica as an etl tool over teradata?

1022

---

Is stop and abort are same in informatica?

1002

---

if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.

2199

---

what are the best practices to extract data from flat file source which are bigger than 100 mb memory?

2359

---

Where are the source flat files kept before running the session?

1078

---

5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C

1910

---

Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?

1902

---

What are the modules in Power Center

1680

---

What are the different types of transformation available in informatica.

1105

---

Whats the difference between informatica powercenter server, repositoryserver and repository?

1174

---

What is status code in informatica?

1020

---

What is the difference between informatica 7.0 and 8.0?

1016

---