Answer / shashiall

Run the procedure to load the ttime dimension.Its not
loaded frequently,but once or twice a year.

design of staging area?

0 Answers  

---

connected and unconnected lookups?

4 Answers  

---

what is the size of your data warehousing?

0 Answers   IBM,

---

delete data from staging table as it loads to target table.here is the case we are getting data from 3 different server.a b and c.the data from server A loaded into staging table and we ran the task and data loaded to target table.now today data from server B and C also got loaded to the staging table.now what techniques and what transformations should be used to delete only the data which has been loaded only to the target.we need to delete only that data from staging which has been loaded into the target.looking for your responses

2 Answers   Motorola,

---

what is the location of parameter file in informatica?

1 Answers   TCS,

---

---

 Code page compatibly –Where all changes are made to handle the scenario.

1 Answers   DELL,

---

What is router transformation

4 Answers   CSC,

---

What is data movement mode in Informatica and difference between them?

0 Answers  

---

how you will maintain version?

3 Answers   CTS, TCS,

---

Hi ETL gurus can any one tell me with a flow how to implement SCD Type 1 and SCD Type 2 in a single mapping.For some fields SCD type has to be implemented and for some fields scd type has to be implementd..Thank in advance..please let me know in case of any concerns...

1 Answers  

---

Which is costliest transformation? costly means occupying more memory?

3 Answers  

---

What are the mapping parameters and mapping variables?

0 Answers   Informatica,

---