Answer / priyaraj

Pre SQL means that the integration service runs SQL
commands against the source database before it reads the
data from source.

Post SQL means IS runs SQL commands against target database
after it writes to the target.

i hav a scenario like this i want load data from source to target as follows frist it counts the num of deptno and display with that with count and how many times it reapts along with all the records in source

1 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,

---

i have 2 flat files one table contains duplicates another one no duplicates.... so i need like this i don't want duplicates...pl's give me ans...

4 Answers   Keane India Ltd,

---

what is data driven in update strategy transformation?

2 Answers   HCL, PayPal,

---

Could you explain what is enterprise data warehouse?

0 Answers  

---

What is informatica?

0 Answers  

---

Useful UNIX commands regular/frequently used

1 Answers   Deloitte,

---

I have 5 sessions s1,s2,s3,s4 & s5 and i want execute s1,s2,s3,s5 after s4. How?

8 Answers   DELL,

---

Informatica software installation 8.1/7.1.3/7.1 with oracle 10g database (optional Teradata v2R6)

1 Answers  

---

Please explain in detail with example about 1.Confirmed Dimension. 2.Junk Dimension. 3.Degenerated Dimension. 4.Slowly changing Dimensions

3 Answers   Infotech,

---

What are the differences between oltp and olap?

0 Answers  

---

what is the complex transformation you used in informatica

0 Answers   TCS,

---