Answer / sri ram

Time Dimension:Generally, to generate dates as per the
requuirement we use date dimension.

If your loading of data in fact table on the basis of
time/date then we use the values of date dimension to
populate the fact.

we take the last date on which the fact is populated. Then
check for the existence of dates for the data to be
populated.ifnot we generate through some stored procedure
or as per requirement.

Eg:Daily,weekly,financial year, calender year, business
year etc.,

Answer / shaheem qhizer

Example of time dimension is Calender year.

How does the server recognize the source and target databases. Elaborate on this.

1 Answers  

---

explain abt union t/r?

1 Answers   IBM,

---

write a query following table bookid language 1234 english 1234 french 1234 spanish 1235 english i want the output are bookid lang1 lang2 lang3 1234 english french spanish 1235 english null null

1 Answers   TCS,

---

What are the types of maping in Getting Started Wizard?

1 Answers  

---

wat s mapping parameter and mapping variable? how do you set that in a mapping?

3 Answers  

---

how we can load rejected record's at run time?(not through bad files)

0 Answers   TCS,

---

Which tool yoU use to create and manage sessions and batches and to monitor and stop the informaticaserver?

4 Answers  

---

can you use flat file for lookup table?why?

2 Answers   HCL,

---

Transformer is a __________ stage option1:Passive 2.Active 3.Dynamic 4.Static

2 Answers   Accenture,

---

what is persistant cache in which situation we will use persistantcache

1 Answers   HCL,

---

i have different sources in different databases ,that sources may be 100 tables i want to load these tables in to single target how to pearform the task

14 Answers   Altisource, TCS,

---

In Lookup transformation a sql override should be done and disable the cache how do you do this procedure?

1 Answers   Wipro,

---