Can we insert and update a target table without using update strategy transformation?How?

4 Answers   Syntel,

---

What is factless fact schema?

1 Answers  

---

If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?

0 Answers  

---

Why touse stored procedure in ETL Application?

2 Answers  

---

write sql query following table amount year quarter 1000 2003 first 2000 2003 second 3000 2003 third 4000 2003 fourth 5000 2004 first 6000 2004 second 7000 2004 third 8000 2004 fourth i want the output year q1_amount q2_amount q3_amount q4_amount 2003 1000 2000 3000 4000 2004 5000 6000 7000 8000

1 Answers   HP,

---

---

If we set dd_insert in mapping and Delete in session properties what will happen.?

4 Answers   IBM,

---

What are the unsupported repository objects for a mapplet?

1 Answers   Informatica,

---

In router source is a boy age 20 I given 3 conditions in router a>20, a<=20, a=20 which one exit first?

3 Answers  

---

hi, as al you know, we can set the option in session level as all rows treat as like insert,update etc., And also we have update strategy for flaging records as insert,update etc.. then when we will go for above options and what is the difference.. explain..

1 Answers   Wipro,

---

explain about session partitions ?

1 Answers  

---

Can we update a target table (without primarykey) by using update strategy transformation?

4 Answers   TCS,

---

What are the modules in Power Center

0 Answers  

---