Answer / shashiall

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

What is the difference between a repository server and a powerhouse?

0 Answers  

---

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,

---

How can one know that a table has indexes and is partitioned? How data will be pulled from Partitions in Oracle for Informatica?

1 Answers  

---

To provide support for Mainframes source data,which files r used as a COBOL files

1 Answers  

---

Do you have to change the reject file b4 using reject loader utility.

1 Answers  

---

We can achieve better perfomance using sorter before an aggragator. Then what is the significance of 'Sorted Input' check in aggregator ?? Please let me know the difference ??

2 Answers  

---

can we use bulk loading when we use look in mapping

1 Answers   TCS,

---

What is the grain level in DWH? If i have year to day. what is the grain level of DWH from year to day.

1 Answers   Zensar,

---

which transformation uses cache?

3 Answers   Keane India Ltd,

---

tell me about your project functionality

0 Answers  

---

Session Recovery. 1000 rows in the source of which 500 passed through and then I killed the session. Can you perform a recovery and how

1 Answers   IBM,

---

What are the issues that you have faced while moving your project from the Test Environment to the Production Environment? Please explain in depth thanks in advance

3 Answers  

---