Answer Posted / sukanta

how your rank will look like

let suppose
ename sal
a 1000
b 1000
c 2000
d 1000
e 2000
and rank will work upon sal column.

what will be your target as per informatica rank works

ename sal rank
a 1000 1
b 1000 1
d 1000 1
c 2000 4
d 2000 5

if your rank will like this

ename sal rank
a 1000 1
b 1000 2
d 1000 3
c 2000 4
d 2000 5
or

ename sal rank
a 1000 1
b 1000 1
d 1000 1
c 2000 2
d 2000 2

all are can be done by using expression
transformation,sorter and aggrerator transformation combined
in a mapping.

Regards

Sukanta

Define mapplet?

998

---

I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?

1752

---

What is resilience time?

1109

---

How do you take back up of repository?

1138

---

Mention a few design and development best practices for informatica?

979

---

Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?

1653

---

Briefly describe lookup transformation?

1031

---

What is domain and gateway node?

1153

---

I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.

1263

---

Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?

1264

---

What are the features of complex mapping?

1146

---

What do you understand by a term domain?

1110

---

Define pmcmd command?

1028

---

What is Index Caches size?

1095

---

what is the size of u r source(like file or table)?

2253

---