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

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

1172

---

How to delete duplicate row using informatica?

1044

---

Partition, what happens if the specified key range is shorter and longer

2493

---

How to convert multiple rows to single row (multiple columns) in informatica

1377

---

1. When u r checking out what ll happens for version no? a. Increase b. decrease c.reset to 0 d. reset to 1 e. no change 2. Salary of all employees needed to add with the commision. What transfrmation to be used? a. SQ and Expression b. SQ c. Update Strategy d. Expression 3. Which of the task is used to run a session based on success of the other session? a. Decision b. Event wait c. Email d. Command e. None 4. Types of sources in Informatica? a. Homogenous n Heterogenous b. None c. Cobol n XML d. Flat files e. Flat files and Homogenous n Heterogenous 5. Servers are available in informatica? a. Informatica Server and Workflow server b. Informatica Server and Informatica Repository Server c. Informatica Server d. Workflow server e. Informatica Repository Server 6. While using Pmcmd in cmd line mode, each command must include the connection info of which of the following? a. workflow manager b. Power Center server c. Workflow monitor d. Repository manager e. Designer 7. Workflow montior displays workflows that have run a. once b. twice c. never d.four times e. thrice 8. Mode for handling sessions n workflows? a. server mode b. Wait mode c. Command line mode d. User mode e. Interactive mode 9. Connection details configured in? a. Mapping designer b. Workflow manager c. Workflow monitor d. Repository manager e. Worklet designer Thanks in Advance

4183

---

Explain informatica architecture - version 8 / 9

1087

---

Explain sessions and how many types of sessions are there?

1006

---

Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.

2302

---

What is native users?

1147

---

What is a filter transformation?

1042

---

How many transformations can be used in mapplets.

1933

---

What is a code page?

1175

---

What is data caches/ index caches?

1099

---

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

1126

---

How can you generate reports in informatica?

1025

---