Answer / bsgsr

stored procedure transformation can be used to create and
drop indexes before and after loading into the target.

Answer / kalyan

use the post session SQL to craete indexes on the target
table..

Answer / prasad

unconnected stored procedure with the property called target
post load

What is informatica etl tool?

0 Answers  

---

which is better perfomancewise lookup or joiner and why?can anyone give example?

6 Answers   TCS,

---

i have a flat file and the file s are like below ****%%^^@@@G**@#A@#$N*&^E%^S@#h@@@##$$ IN THIS FORMATE Means un limited special charecter between and sides of the string data..output should be(GANESH) HOW YOU HANDEL THIS TYPE OF RECORDS,,COZ U DON"T KNOW WHERE AND WHAT ARE THE SPECIAL CHARACTERS IN BETWWEN THE NAME...

6 Answers   IBM,

---

what are the settiings that u use to cofigure the joiner transformation?

2 Answers  

---

if soource is having 10 records how will u insert 20 records to target

6 Answers   HCL,

---

Mapplets can you use an active transformation in a mapplet,

1 Answers  

---

How can i catch the Duplicate Rows From SorterTrans in a Seperate Target Table ?

2 Answers  

---

WHAT IS THE DIFFERENCE B/W 7.X AND 8.X ? TELL ME FEW DIFFERENCES.

2 Answers  

---

In Real Time what are the scenarios u faced, what r the tough situations u have overcome, and explain about sessions.

2 Answers   Cap Gemini, CTS, TCS, Tech Mahindra, Wipro,

---

What is exact use of 'Online' and 'Offline' server connect Options while defining Work flow in Work flow ?

1 Answers  

---

What are the different types of Type2 dimension maping?

2 Answers   CTS,

---

If we have 1000 rows were loaded in to datawarehouse and next day the source have 1010 rows so, how can we loaded only updated rows into target.

6 Answers   Accenture,

---