Answer Posted / 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

What is intricate mapping?

1174

---

What are the types of schemas we have in data warehouse and what are the difference between them?

924

---

What are the advantages of using informatica as an etl tool over teradata?

1008

---

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

1083

---

Explain informatica architecture - version 8 / 9

1073

---

Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.

2395

---

how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.

1679

---

What is meant by active and passive transformation?

1111

---

Hi, In source I have records like this No name address 10 manoj mum 10 manoj dilhi 20 kumar usa 20 kumar Tokyo I want records in target like shown below No name addr1 addr2 10 manoj mum dilhi 20 kumar usa Tokyo If it is reverse we can do this by using Normalizer transformation by setting occurance as 2. Somebody will say use denoralization technique. But as of my knowledge I couldn’t find any denormalization technique. Is there any concept like that? I tryid this seriously but I could find any idea to implement this. Can any one please help me ? Advance Thanks

8051

---

How do you update the records with or without using update strategy?

1097

---

Can you use flat files in Mapplets.

2643

---

What is the difference between stop and abort in informatica

1074

---

What is a grid in Informatica?

1059

---

Define sessions in informatica etl?

1013

---

Is it possible to define a single node as a Gateway node as well as worker node?

1105

---