Answer Posted / suresh

actually on lookup two ways we can put the values normally
we put a anyvalue(if you want to both duplicate values).
when we use SCD type 2 its must and should put on last value
into the look up Bcoz it should store the history.

How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how

1573

---

explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?

2096

---

without table how to come first record only in oracle?

2203

---

can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com

4676

---

How many ways a relational source definition can be updated and what are they?

951

---

According to his methodology what all you need before you build a datawarehouse

1689

---

Explain the tuning lookup transformation - informatica

950

---

Explain how many types of dimensions are available in informatica?

1005

---

How to improve the performance of a session using sorter transformation?

1091

---

in reporting we add some new objects,how we get the count of the newly added objects to the report

2129

---

How do you migrate data from one environment to another?

1041

---

Dimension Object created in Oracle can be imported in Designer Cubes contain measures

2312

---

During the running session, output files are created by informatica server. Enlist few of them.

928

---

What is a surrogate key?

1015

---

What is the advantage of informatica?

1012

---