Answer / vaishali bisht

whenever we load data in flat file it automatically override the old data.

Answer / james

whatever data u want to delete from target table,simply go
with truncate option.

What are the Advantages of de normalized data?

3 Answers  

---

Hi , Please help how to achieve the following scenario. I have a source table like this. Rollno name class university 1 Raj 1st Sku 2 Ram 2nd SVU 3 Sam 3rd OU I need the data in the target table like below. Rollno name class university 1 Raj 1st Sku 2 Ram 2nd SVU 3 Sam 3rd OU 4 Rajesh 5th SKU The Last row values we have.. and we have to append this last row in the target table. Thanks and Regards Nataraj V

3 Answers   NTT Data,

---

How will you update the first four rows and insert next four rows in a mapping?

5 Answers   CTS,

---

Can you copy the batches?

3 Answers  

---

I have 2records in target table and this record is deleted in source. Now if I run mapping twice how many records do target will have,  source having 10records. Same with incrementally.  Please  answer me ASAP. 

1 Answers   Cipla, Quintiles,

---

State the limitations where we cannot use joiner in the mapping pipeline?

0 Answers  

---

What is the need for an etl tool?

0 Answers  

---

What is depict expression change?

0 Answers  

---

there is a product table prodid prodname price 100 cinthol 10 101 hamam 10 102 neem 20 103 cake 30 in the above table the price of some products are duplicated and some product prices are distinct we want to push the duplicated prices to one target and non-duplicated prices to other target without using expression and sequence generator transformation

4 Answers  

---

How many ways are there to create ports?

0 Answers   Informatica,

---

What is the capacity of power cube?

1 Answers  

---

what is the drillup & drill down?and use of the drill up and drill down?

1 Answers   IBM,

---