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

Two workflows are running at same time first workflow is succeeded but second workflow is failed but there is no dependencies?

1 Answers   IBM,

---

how many repositories can v create in informatica .

3 Answers   Cap Gemini, Tech Mahindra,

---

waht type of interface is used for testing the data in informatica

0 Answers   CTS, TCS,

---

Dependecy Errors in Informatica ? Do u got any dependency problems while running session? Can any one Explain Clearly.

2 Answers   CTS,

---

what is mean by throghput? in informatica

3 Answers   Cap Gemini,

---

---

Flat file heaving 1 lack records and I want to push 52000 records to the target?

7 Answers  

---

Had any one faced informatica(ETL/Developer), Datawarehouseing interview in UK. Than plz help me (i have any exprience of 3yrs informatica,datawarehousing,oracle,teradata) 1.hw the procedure will b here 2. wht type of question's they will b asking. 3.In which area they concertate more. since this is the first time im facing interview in UK. plz help ASAP.it will b a great help for me thanks to All in Advance

2 Answers  

---

enterprise datawarehouse your project phase by phase explain?

1 Answers   Cap Gemini,

---

What is the query to find nth highest salary? What is the use of cursors?

8 Answers   Keane India Ltd,

---

What are the ETL tools available in DWH?

6 Answers   Mphasis,

---

Why do you use Mapping Parameter and mapping variable?

0 Answers  

---

i have source flat file like 1 a,1 b,1 c,2 a,2 b,2 c i want output as 1 a,b,c and 2 a,b,c ... how can achieve this

5 Answers   TCS,

---