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.

Do joiner transformation use cache? If so describe?

2 Answers   Patni,

---

I've an excel sheet, in which one column contains data about the location like "City, State" and few columns contains only "State". Now I wanna load into my target City and State into two different columns. Pls help me out...

6 Answers   TCS,

---

we have tables like c1 a c2 b c3 c c4 x c5 y and i need output like abcx in a single row and abcy in a single row? how do u do this?

2 Answers   Patni, Tech Mahindra,

---

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  

---

How your source files are coming to your ETL server. Actually at which stage of your mapping it is happen.

1 Answers   Cognizant,

---

How to run a session, which contains mapplet?

1 Answers  

---

How to import oracle sequence into Informatica?

3 Answers   Satyam,

---

When the informatica server marks that a batch is failed?

1 Answers  

---

If in a workflow i have n number of sessions and each session is configured with different different stop on errors (say 5,8,10 etc respectively).How can make all this same for all the sessions with out actualy touching each and evry session ?

1 Answers   Wipro,

---

How do you handle two sessions in Informatica

0 Answers   Informatica,

---

What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks

2 Answers   IBM,

---

What are the out put files that the informatica server creates during the session running?

2 Answers  

---