Answer Posted / michelle

HI

I am also looking to get certified in informatica. Can
someone please forward me the dump of all three
certificaions as well. my email is rwork.san@gmail.com

Thanks in advance

What are the three tiers in etl?

1113

---

how do u really know that paging to disk is happening while u are using a lookup transform?

1986

---

Difference between flat files and relational sources?

2311

---

When do we use dynamic cache and static cache in connected and unconnected lookup transformations? Difference between stop and abort

978

---

what are the concerns of OLTP and DSS systems?

2450

---

how to load the data to fact table?

2704

---

What are the differences between sql override and update override?

1101

---

Hi, I completed MCA in 2006.After studied Informatica,SQL server and basics of reporting tool in one of the training center in chennai.I got subject knowledge only.But I didn't go any job because I scared to face real time.Anyone please advice how can I enter again into this and anyone provide real time exposure with project.

1808

---

In informatica, I have 10 records in my source system. I need to load 2 records to target for each run. How do I do this?

934

---

what is a worklet?

995

---

when u connect the repository for the first time it asks you for user name & password of repository and database both.But subsequent times it asks only repository password. why?

2175

---

How to recover a workflow? What are the different approaches?( In prod i.e no access to modify)

1198

---

What do you understand by the term ‘transformation’?

1039

---

how do u estimate the depth of the session scheduling queue? Where do u set the number of maximum concurrent sessions that Informatica can run at a given time?

2891

---

How many steps etl contains?

944

---