Answer / guest

we use lookup transformation to lookup data in a relational
table ,view or synonym.and by using lookup transformation
we can perform the following jobs
-to get the related value
-to perform the calculations
-to update the slowy changing dimentions

1.what is SDLC of a project,explain in detail? 2.what are dimensions,facts?what is confirmed dimensions? 3.what is the need of OLTP? when we have datawarehousing?

2 Answers   Accenture,

---

How do you implement scheduling in Informatica?

1 Answers  

---

Can you generate reports in Informatcia?

1 Answers  

---

My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?

0 Answers  

---

i have 2 mapings for this 2 mapings i want use only one lookupt/r how?

3 Answers   Wipro,

---

What is rank transformation?

0 Answers  

---

What are set operators in Oracle

3 Answers   Deloitte, Wipro,

---

Write the unconnected lookup syntax?

0 Answers  

---

Explain the different lookup methods used in informatica?

0 Answers  

---

 Informatica Checkpoints

0 Answers   DELL,

---

Explain the types of transformations?

0 Answers  

---

wtite sql query following table are city gender no chennai male 40 chennai female 35 bangalore male 10 bangalore female 25 mumbai female 15 i want the output? city male female chennai 40 35 bangalore 10 25 mumbai null 15

3 Answers   Bank Of America,

---