Answer / susheel sharma

in our project we used store procedure to implement CDC
(change data capture) for incremental data load.

generaly store procedure used when you have to implement
your complex business logic.

Answer / grhyrngnn yjhyj

i used to stored procedure for time conversion,droping and
creating indexes,for loading time dimension,to know the
status of the database,to know the space availble.

Filter condition at workflow level & filter condition at mapping level . Which will get preference or which will work.

2 Answers  

---

yesterday my session run ten min.today its run 30min, wt is the reason? if any issues how to solve that?

2 Answers   iGate,

---

checkout and checkin in informatica 8.6

3 Answers   TCS,

---

How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix.

1 Answers   DELL,

---

How to partition the Session?

0 Answers   Informatica,

---

---

What are active transformations? Name them.

1 Answers  

---

What is source qualifier transformation in informatica?

0 Answers  

---

What is the use of target designer?

0 Answers  

---

what is mapping optimization? wat are the techniques for tat

2 Answers  

---

Define maping and sessions?

3 Answers  

---

case and like function in informtica (my source is XML). case when OS Like'%Windows%' and OS Like '%200%' then 'Windows 200' case when OS Like'%Windows%' and OS Like '%200%'and OS like '%64%' then 'windows 200 64 bit' etc.,,

1 Answers  

---

Plz..let me know differences between Informatica 7.1 and 8.1?

3 Answers  

---