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 we use only lookup transformation in a mapping ie, SourceQualifier-->Lookup --> Target. , here datas are taking very long time to load in target., so what are steps to improve the performance in that mapping???????

2 Answers  

---

What is the difference between OLTP and ODS?

4 Answers  

---

if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.

0 Answers   iGate,

---

How we can use union transformation?

0 Answers  

---

What is a unit Testing?

1 Answers  

---

Hi, source data is col1 values are 5,6,7 col2 are 3,2,1 col3 are 8,9,10 and i want to get target as col1 5,6,7 col2 1,2,3 col3 8,9,10 how to do this one?

6 Answers  

---

what is the difference between informatica6.1 and infomatica7.1

0 Answers   TCS,

---

Hi, Can someone send me the DWH and Informatica FAQ's at priti.singh84@gmail.com Thanks in Advance, preeti

1 Answers   Accenture, Patni,

---

SOURECE Name id dept sal 1 a1 A 100 2 b1 B 200 3 c1 C 300 4 d1 D 400 TARGET: Name id dept sal 1 a1 A 100 2 b1 B 200 3 WER1 567 300 4 d1 D 400 I HAVE SOURCE AND TARGET. HOW TO VALIDATE DATA? TELL ME 5 STEPS ABOVE TABLE?

1 Answers   IBM,

---

Find a way to implement the following logic : You have column like : Column 1 AA|BB|CC DD|EE|FF WW|AA I need to get the length of the column without the ‘|’ .

5 Answers  

---

Which files are created during the session rums by informatics server?

0 Answers  

---

What is the "File Repository" and how can we use that in the Informatica ? Please give one example of the Process ? waiting for Reply... Thank you .

4 Answers  

---