Answer / swetha

Insert

Delete

Update

Update as update

Update as insert

Update esle insert

Truncate table

Answer / santhoshi

INSERT
UPDATE AS UPDATE
UPDATE AS INSERT
UPDATE ELSE INSERT
DELETE
TRUNCATE TARGET TABLE

which transformation should we use to get the 5th rank member from a table in informatica?can we achieve this in sql?

6 Answers   IBM,

---

What is meant by pre and post session shell command?

0 Answers  

---

What are active transformations? Name them.

1 Answers  

---

what is the difference between lookupoveride and joiner?

3 Answers  

---

what is bridge tables in informatica

1 Answers   CTS,

---

Hello Everyone,i have one question on sequence generator.i have two targets and the records comes from the source will place in the targets like 1-10 rec in target1 and 11-20 rec in target2,21-30 rec in target1...etc so any one can help me? plz..Thanq in adv.

7 Answers   Cognizant, Wipro,

---

In warehouses how many schemas are there?

0 Answers  

---

Limitation of REPLACESTR. Is there any character limitation to it.

1 Answers   CTS,

---

Want to know about Training Centres for Informatica, Cognos and ETL Softwares in Mumbai, India.

27 Answers  

---

Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM

1 Answers   IBM,

---

Can we have a Mapping without a Source Qualifier?

14 Answers   Deloitte,

---

can we use mapplet as starting n ending object in mapping

2 Answers   TCS,

---