Answer Posted / suneet bajwa

Hi,

Please send me the informatica certification dumps to this
id:
bajwasuneet@gmail.com

Thanks,
Suneet Bajwa.

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

1719

---

how do u identify the changed records in operational data?

2477

---

what is session partitioning?

2042

---

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)

2628

---

What is a materialized view log?

950

---

How can we use external procedural logic in informatica?

873

---

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

2382

---

What do you understand by the term ‘transformation’?

958

---

two sources S1,S2 containing measures M1,M2,M3, 4 dimensions D1,D2,D3,D4, 1 Fact F1 containing measures M1,M2,M3 and surrogate keys K1,K2,K3,K4 (a) write a sql statement to populate Fact table F1 (b) Design a mapping in Informatica for loading of fact table F1.

2010

---

What is Data Vault???

2683

---

give detail on the sales project how many number of dimensions & fact tables are used in projec briefly. how the four fact tables taken in the project.

2313

---

How can you use an Oracle sequences in Informatica ? You have an Informatica sequence generator transformation also. which one is better to use?

2224

---

what is the main role of FI on business

2037

---

What are the three tiers in etl?

1037

---

How etl testing is different from database testing?

968

---