Answer Posted / amedela chandra sekhar

write sql query in the source qualifier t/r

sql override

select * from(select dense_rank () over (order by sal desc
nulls last)as rnk,emp.* from emp)where rnk<=10;

Is there any target staging area in informatica not staging area

2631

---

explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?

2200

---

Describe expression transformation?

1170

---

I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.

1801

---

What is the difference between a repository server and a powerhouse?

1578

---

Write the unconnected lookup syntax and how to return more than one column.

1150

---

What is mapplet in informatica?

1129

---

How you know when to use a static cache and dynamic cache in lookup transformation?

1918

---

Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.

2481

---

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

1221

---

If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?

10321

---

What is the benefit of partitioning a session?

1236

---

Explain sessions and how many types of sessions are there?

1059

---

What is flashback table ? Advance thanks

1998

---

What are the basic requirements to join two sources in a source qualifier transformation using default join?

1212

---