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

Tell me about Propagate functions in informatica

976

---

what is index?how it can work in informatica

2081

---

How to partition the Session?

1149

---

What are the different components of powercenter?

1110

---

Explain the mapping variable usage example in informatica

1224

---

define galaxy repository in informatica

2285

---

What do you understand by a term domain?

1170

---

How can we use mapping variables in informatica? Where do we use them?

1280

---

What is the use of code page?

1169

---

can we override a native sql query within informatica? Where do we do it?

1163

---

Make a note of the quantity vaults made in informatica?

1042

---

The question was on time stamp. what is the difference between HH and HH24 when to use when.

2120

---

What is Data Caches size?

1127

---

How many transformations can be used in mapplets.

1980

---

Write the unconnected lookup syntax?

1129

---