Answer / srikanthlavu

By using infor matica we will design one to many relation
ship between fact and dimension tables..By using Business
object we will take those relational tables and will
prepare reports

When the informatica server marks that a batch is failed?

2 Answers  

---

how can we convert a column into row in informatica? Eg: INPUT- a x Output Like: a b c b y x y z c z

3 Answers   CTS,

---

What is sequence generator transformation in informatica?

0 Answers  

---

Briefly define a session task?

0 Answers  

---

Define Update Override?

1 Answers  

---

What is the difference between view and materialised view?

4 Answers  

---

Hi, I am working on informatia in a support role. We used stored procedures in informatica and other than that I never got a chance to work on PL/SQL,little on Unix scripts. But I heard people asking about PL/SQL alot. Can any one let me know how do we use PL/SQL with informatica and if required what is the knowledge that we need to have on PL/SQL? Please let me know in detail which would really help me alot in my career prospectus.

1 Answers   Accenture,

---

What are the types of lookup transformation?

0 Answers   Informatica,

---

i have n number of records in my source, i want first and last record to my target. how can u implement this scenario .

6 Answers   Emphasis,

---

What is a stored procedure transformation?

0 Answers  

---

If we can implement SCD TYPE 1 AND 2 IN A SINGLE MAPPING.. CAN WE SEE THE RESULT IN A SINGLE OUTPUT? I MEAN I WANT THE RELSULT OF BOTH SCD 1 AND 2 TO BE SEEN IN A SINGLE RUN?

1 Answers   TCS,

---

Define informatica repository?

2 Answers   Wipro,

---