Answer / Yogesh Pratap

Rank Transformation in Informatica is a data manipulation tool used to assign a rank or sequence number to each row within a sorted set of data based on a specified column. It can help you identify the first, last, or nth occurrence of each unique value in your dataset.

what is the logic will you implement to laod the data in to one factv from 'n' number of dimension?

3 Answers  

---

What is source qualifier transformation in informatica?

1 Answers  

---

What are the different threads in DTM process?

1 Answers  

---

r u done any partitions in ur project?

1 Answers   TCS,

---

What is informatica worklet?

1 Answers  

---

How did you handle performance issues If you have data coming in from multiple sources, just walk thru the process of loading it into the target

1 Answers  

---

in which situations do u go for sequence generator ?

2 Answers   TCS,

---

Is it necessary to maintain the primary-foreign key relation ship between the targets in informatica while loading using constarint based loading or it is required only at database level ??

1 Answers   IBM,

---

Why we use stored procedure transformation?

4 Answers  

---

What is difference between partioning of relatonal target and partitioning of file targets?

2 Answers  

---

Describe the impact of several join conditions and join order in a joiner transformation?

1 Answers  

---

What is a dimensional model?

1 Answers  

---