Answer / tamilarasan

Factless fact table - it doesn't have any measures
There are types in this
Additive : we can calculate all the aggregate function in this
Semi: we can do only particular calculation
Non : no calculation can be done

Explain scd type 3 through mapping.

0 Answers  

---

There are n numbers of flatfile of exactly same format are placed in a folder .Can we load these flatfile's data one by one to a single relational table by a single session??

9 Answers   TCS,

---

how DTM buffer size and buffer block size are related

3 Answers   Wipro,

---

Hello...... How can i set my mapping as read-only? Please answer me. Advance thanks

4 Answers  

---

In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?

1 Answers   HP,

---

---

What is the status code in stored procedure transformation?

0 Answers   Informatica,

---

i want to load data in to two targets..one is dimension table and the other is fact table?how can i load ata a time

3 Answers   iGate,

---

I want expect first and last record remaining all records will be loaded into target? which transformations we can use?

6 Answers   Cap Gemini, CTS,

---

Briefly define reusable transformation?

0 Answers  

---

When you connect to 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?

1 Answers  

---

Explain the use of aggregator cache file?

0 Answers  

---

Explain the different kinds of facts.

0 Answers  

---