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

I want skip first 5 rows to load in to target? what will be the logic at session level ??

1 Answers   IBM,

---

what r d pre-requiste for update strategy transformation, and differnce between delete n truncate in target session properties for update strategy

2 Answers   TCS,

---

How to delete duplicate records in a flat file source?

2 Answers  

---

While migrating the data from one environment to another environment how would you manage the connections?

0 Answers  

---

design of staging area?

0 Answers  

---

what are presession,postsession success and postsession failure commands ?

1 Answers  

---

what is mean by flag 4 in update strategy t/r

6 Answers  

---

I have 4 columns in a table say, name ,address, salary and city. So based on distinct city names, i need to combine the other data and send it to a flat file. Distinct city names can be 4 or 5 or 6. So it has to dynamically generate flat files(4 or 5 or 6) corresponding to the city names.

2 Answers  

---

how to work with mapplet designer in informatica?

7 Answers  

---

1:when we develop a project what are the performance issue will raise?? KPIT 2:if a table have INDEX and CONSTRAINT why it raise the performance issue bcoz when we drop the index and disable the constraint it performed better??KPIT 3:what are unix commands frequently used in informatica??

1 Answers   KPIT,

---

Why do we use DSS database for OLAP tools?

2 Answers  

---

what is data driven in informatica

5 Answers   IBM,

---