Answer / swathi

data driven is available at session level.it says that when
we r using update strategy t/r ,how the integration service
fetches the data and how to update/insert row in the
database log.

Answer / teja_dwh

Data driven is nothing but but instruct the source rows that
should take action on target i.e(update,delete,reject,insert).
If we use the update strategy transformation in a mapping then
will select the datadriven option in session.

reply me if am wrong
teja_dwh@yahoo.com

If u r using dynamic cache lookup port will be thier in thet which option u will select

1 Answers   HCL,

---

What is the format of informatica objects in a repository?

0 Answers  

---

empno sal 1 8000 2 9000 3 8000 4 1000 how to get highest sal wise rankings in rank t/r.

3 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 can anybady help me to achieve the aboue result by using informatica. thanks in advance.

5 Answers  

---

suppose if we have dublicate records in a table temp n now i want to pass unique values to t1 n dublicat values to t2 in single mapping using aggregator & router? how

7 Answers   TCS,

---

What is pmcmd command?

0 Answers  

---

Hi Friends, How i could convert a cobol file (VSAM) into the flat file? How i could edit a cobol source file (VSAM)? I want to introduce few columns in the source file and finally the target should be in the Cobol itself. Kindly suggest me friends. Thanks in Advance, Innai

1 Answers   Infosys, Saksoft,

---

Is scd logic we have lookup right to compare the values with source and target,instead of lookup can u have any transformation or any way to do this?

2 Answers  

---

what is runtime variable?

3 Answers   TCS,

---

What is reconstalation n What is fact constalation? Correct me if i m wrong in the question.

2 Answers   Mphasis,

---

hi all, can anyone please tell me the difference between erwin tool and informatica ?how these both works ? how this both are going to connect with business objects. THANKS IN ADVANCE

2 Answers  

---

how DTM buffer size and buffer block size are related

3 Answers   Wipro,

---