Answer / sivaprasad

Update strategy defines the sources to be flagged for
insert, update,
delete, and reject at the targets.
What are update strategy constants?
DD_INSERT,0 DD_UPDATE,1 DD_DELETE,2
DD_REJECT,3

If DD_UPDATE is defined in update strategy and Treat source
rows as INSERT in Session . What happens?
Hints: If in Session anything other than DATA DRIVEN is
mentions then Update strategy in the mapping is ignored

Answer / chluff12

to decide to insert, update, delete or reject the data.

Can we schedule a workflow(not a session) to run after completition of another workflow? Can we make a workflow depend on completition of another one?

2 Answers   GE,

---

How does the server recognize the source and target databases. Elaborate on this.

1 Answers  

---

What are the tasks that source qualifier perform?

0 Answers   Informatica,

---

what is runtime variable?

3 Answers   TCS,

---

Can we use Lookup instead of Joiner to join 2 tables? If yes which is faster and why?

2 Answers   TCS,

---

What is powercenter on grid?

0 Answers  

---

When will you use SQL override in a lookup transformation?

1 Answers  

---

What is Performance tuning in Informatica?

1 Answers   CTS, GE, TCS,

---

tell me the datawarehouse defination,and it is maintaing hystorical data meaning,what is the use

1 Answers  

---

Enlist the various types of transformations.

0 Answers  

---

In development project what is the process to follow for an etl developer from day1

0 Answers  

---

There are 4 flat files with number of records as indicated below. Which files should be picked first for joining using joiners so as to get best performance. File A - 1000 records File B - 100 records File c - 10000 records File D - 10 records Please explain. Thanks and Regards,

1 Answers   Amdocs,

---