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

What is an expression transformation?

972

---

Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure

7268

---

Explain load alternative records / rows into multiple targets - informatica

1102

---

Enlist the differences between database and data warehouse.

1035

---

Design time, run time. If you don't create parameter what will happen

1798

---

What is the difference between writing a joiner query in ANSI style and THETA style?

2323

---

What is a filter transformation?

991

---

What are the differences between a connected lookup and unconnected lookup?

1017

---

Can we override a native sql query within informatica?

989

---

What is workflow monitor?

1000

---

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

1205

---

What the difference is between a database, a data warehouse and a data mart?

1083

---

What is a node in Informatica?

1004

---

Can we create a Integration service without a Repository service and vice versa?

1175

---

How might one distinguish in the case of mapping is right or not without associating session?

1028

---