Answer Posted / prem

Please fwd the informatica certification dumps..for below id:
premdotcom@gmail.com
thanks..

How many steps etl contains?

949

---

diff b/w dwh & data mart diff b/w star schema & snow flake schema diff b/w fact table & dimension table what are the contents in requirement specification what are the docs needed for testing draw ur proj architecture

2558

---

what is the difference steps for data modeling?

2146

---

what is dynamic insert?

2210

---

Hi, I've a mapping with flat file source The target update override property for the target table is using update stmt. There is no update strategy between source and target. Also The session has the target properties as Insert , Update as update options checked. Does this mean that recs will be inserted only and the update override will not be applied at all. Thanks

1786

---

Can anyone explain me a scenario from banking and finance...more precisely a mapping

2500

---

What are the differences between sql override and update override?

1105

---

What is partitioning? Explain about round-robin, hash partitioning.

969

---

how does the server recongnise the source and target databases.Elaborate on this

2695

---

Explain about the data integration suite features?

954

---

how would u estimate the size of Lookup transform data and index cache?

2137

---

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.

1814

---

how do u handle performance issues in Informatica . where can u monitor the performance ?

4741

---

How to fine tune mappings?

947

---

Which transformation we use to convert 'NA' to 'Not Available'

1271

---