Answer / venky

write post sql in target table as truncate table tablename

Answer / honey

SQ---> Properties tab-->Post SQL
delete from target_tablename

SQL statments(s) executed using the source database
connection, after a pipeline is run

Answer / davankumar p

we have the property in session truncate option.

Can a joiner be used in a mapplet.

1 Answers  

---

Differentiate between source qualifier and filter transformation?

0 Answers  

---

Explain the etl program with few examples.

0 Answers  

---

My i/p is like below 1,2,3,4,5,6,7,8,9,10....100 I want that to be populated in two o/p as below o/p-1: 10,20,30,40,50,60,70,90... o/p-2: 11,21,31,41,51,61,71,81,91.... How to do it in ingotmatica...

2 Answers   Accenture,

---

Is it passive or active when check and uncheck the box of DISTINCT in Sorter transformation? why?

6 Answers   iFlex, Morgan Stanley,

---

If I have set the property Treat Source Rows as Insert and for the target properties I have checked the boxes Update as Update, what will happen to incoming rows? What exactly is the use of these check boxes and in which scenarios we use them. Also what is the sequence in which informatica understands these properties.Does it takes whatever is defined in treat source rows as property or it is in any other way. Please explain.

3 Answers   Amdocs,

---

2,can we insert duplicate data with dynamic look up cache,if yes than why and if no why?

2 Answers   TCS,

---

how to read data from website into informatica? plsss send answers ASAP thanks in advance.

1 Answers   DELL,

---

What does update strategy mean, and what are the different option of it?

0 Answers  

---

What is the difference between bitmap and btree index?

2 Answers   CTS, TCS,

---

Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?

0 Answers  

---

What is operational data source (ODS)?

7 Answers  

---