Answer Posted / tonychu02

Could You plz send me the informatica exam dumps if
you have it....
My Mail ID: tony_chu02@yahoo.com


Many Thanks

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

1715

---

Two default user groups created in the repository are____and_____.

1973

---

what are the facilities provided by data warehouse to analytical users?

2009

---

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

1130

---

What is data cleaning?

883

---

Assume u have a 24CPU machine with 24GB RAM, suggest how u would like to configure Informatica ,like number of concurrent sessions, RAM requirements etc,max partitions that u would permit per mapping.

1964

---

list and discuss two approaches for updation of target table in Informatica and how they are different.

2056

---

Give a way in which u can implement a real time scenario where data in a table is changing and u need to look up data from it.How will u configure the look up transform for this purpose?

1844

---

What are the names of the layers in etl?

935

---

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?

2835

---

what are the session parameters? How do u set them?

1982

---

how to do aggregation (year wise quantity ) using only source qualifier, the source is sql server date as datetime data type and target as flat file with year (string datatype)

2622

---

How etl testing is different from database testing?

963

---

what is data modeling?

2258

---

what is an ETL or ETT? And what are the different types?

7433

---