Answer / mahesh gupta sreeram

Requirement Analysis
Design
Coding
Testing(Unit testing,Integration Testing etc)
Deployment
Maintenance

Answer / 8/5/08

Requirement and Analysis
Design
Coding
Verification
Maintainance

Answer / satyajit

Feasibility Study
Requirement Analysis
Design
Construction(Coding)
Testing(Unit testing,Integration Testing etc)
Implementaion

What are the types of lookup caches?

10 Answers   Accenture, IBM, Informatica,

---

How to eliminate duplicates in FF and oracle both

3 Answers   CSC,

---

Explain one complecated mapping?

3 Answers   Fidelity, Wipro,

---

Why touse stored procedure in ETL Application?

2 Answers  

---

what are the limitations of pushdown optimization technique ? Advance thanks

3 Answers   Puma,

---

---

write a query following table bookid language 1234 english 1234 french 1234 spanish 1235 english i want the output are bookid lang1 lang2 lang3 1234 english french spanish 1235 english null null

1 Answers   TCS,

---

In Datastage, we have row generator stage to generate dummy row. Is there any such transformation in Informatica. Thanks in advance, Kumar

1 Answers  

---

If I have a index defined on target table and if set it to bulk load will it work ?

4 Answers   IBM,

---

split two strings into two columns For Eg. Source:-Full Name: Shiva Kumar Target:- First Name:Shiva Last Name:Kumar

1 Answers   Cap Gemini, TCS, Wipro,

---

I have id, seq_no date, bill_amt and weight 1,11,'01-Jan-2014',100,2 2,12,'01-Jan-2014',40,5 3,13,'01-Jan-2014',32,5 4,14,'01-Jan-2014',98,2 5,15,'01-Jan-2014',105,3 6,16,'01-Jan-2014',11,3 1,11,'02-Jan-2014',40,2 2,12,'02-Jan-2014',100,5 3,13,'02-Jan-2014',132,5 4,14,'02-Jan-2014',198,2 5,15,'02-Jan-2014',15,3 6,16,'02-Jan-2014',16,3 Now I need output as date MXAMT_LSTWGHT MINAMT_GRTWGHT 01-Jan-2014 100 32 02-Jan-2014 198 100 Could not think of mapping to do so. Please help

1 Answers   Axtria,

---

What is workflow variable? When we use workflow variable? Can any one explain me with one example???

2 Answers   TCS,

---

Data transformed successfully from Source table to target table. Now how you will ensure that the data in Target table is proper. I answered will verify one or two records and check Then question was that the Development is doing (1-2 record verification)but as a tester you have to verify the complete data, how you will do?? Please answer

2 Answers  

---