Answer / rajashekhar

for eg: the file contains the records with coulmn
100
200(repeated rows)
200
300
400
500
the rank function gives output as
1
2
2
4
5
6
and dense rank gives
1
2
2
3
4
5

Answer / ravikumar2614

Rank creates gaps where as densc Rank will not create gaps(between two ranks).
1st answer is correct

Answer / balakrishna

for eg: the file contains the records with coulmn
empno sal
100 1000
200(repeated rows) 2000
200 3000
300 4000
400 5000
500 6000
Rank :

select rank() over (partition by empno order by sal) from
emp

the rank function gives output as
1
2
2
4
5
6
Dense Rank
select dense_rank() over (partition by empno order by sal)
from emp

and dense rank gives
1
2
2
3
4
5

Answer / sunil

dense rank means it is the process of calculating rank for
each group.

deptno rank
10 1
2
3

20 1
2
3

How to retrieve last two days updated records?

4 Answers  

---

What is workflow? What are the components of workflow manager?

0 Answers  

---

Suppose in the next version of Informatica, RTR Xn is excluded. Then how will u route data to different tgts?

2 Answers   Deloitte,

---

Hi All, i have question regarding Change Data Capture in Informatica. As i know we can do this using Incremental Aggregation(i never worked on Informatica but i read) and i think we can do the same with SQL Over write and with variables. Can someone tell me how do we do this using other two techniques.. using SQL Over write and variables. Thanks for the help and greatly appreciated.

1 Answers  

---

if i am having 10 records in source, i want 20 records in target...how will you do it

13 Answers   BirlaSoft, IBM,

---

From where you extract the data, how you did it into informatica? explain....

1 Answers   Accenture, Unisoft Infotech,

---

How can i maintain unique surrogate key if 2 seperate workflows from different repository run and insert/update the main table at the same time.

9 Answers   Barclays,

---

What are reusable transformations in how many ways we can create them?

2 Answers  

---

If a session fails after loading of 10,000 records in to the target. How can you load the records from 10001 th record when u run the session next time?

4 Answers  

---

hi guys i have an question how do you find out weather the column is numeric or combination of char and numbers or it contains char,numeric and special characters.

2 Answers   IBM,

---

tell me 7.x and 8.x diferrencess(but not transformations)

1 Answers  

---

What is target load order?

0 Answers  

---