Answer / vaibhav bhandeo

Data modelling requires understanding of the requirements.
In general the design of data model can be a snowflake
(Highly normalized) or star schema (partial or not
normalized) which depends on whether you want optimal
utilization of space (Use star schema) or you want a
normalized data model easy to query and acess data (Use
snow flake).

what is the main advantage of unconnected lookup

2 Answers   Cap Gemini,

---

How to Explain My project flow,In TCS ased me this question. In which way i can start my project flow and they asked how many fact tables and dimensional tables u used. Can any one Explain Briefly for this question and project architecture also.. please..

3 Answers   CTS, HCL, Infosys, TCS,

---

How to find from a source which has 10,000 records, find the average between 500th to 600th record?

3 Answers  

---

What are the active and passive transforamtions?

2 Answers  

---

In which scenario did u used Mapping variable?

1 Answers   Cognizant,

---

---

How can the following be achieved in 1 single Informatica Mapping. * If the Header table record has error value(NULL) then those records and the corresponding child records in the SUBHEAD and DETAIL tables should also not be loaded into the target(TARGET1,TARGET 2 or TARGET3). * If the HEADER table record is valid, but the SUBHEAD or DETAIL table record has an error value (NULL) then the no data should be loaded into the target TARGET1,TARGET 2 or TARGET3. * If the HEADER table record is valid and the SUBHEAD or DETAIL table record also has valid records only then the data should be loaded into the target TARGET1,TARGET 2 and TARGET3. =================================================== HEADER COL1 COL2 COL3 COL5 COL6 1 ABC NULL NULL CITY1 2 XYZ 456 TUBE CITY2 3 GTD 564 PIN CITY3 SUBHEAD COL1 COL2 COL3 COL5 COL6 1 1001 VAL3 748 543 1 1002 VAL4 33 22 1 1003 VAL6 23 11 2 2001 AAP1 334 443 2 2002 AAP2 44 22 3 3001 RAD2 NULL 33 3 3002 RAD3 NULL 234 3 3003 RAD4 83 31 DETAIL COL1 COL2 COL3 COL5 COL6 1 D001 TXX2 748 543 1 D002 TXX3 33 22 1 D003 TXX4 23 11 2 D001 PXX2 56 224 2 D002 PXX3 666 332 ======================================================== TARGET1 2 XYZ 456 TUBE CITY2 TARGET2 2 2001 AAP1 334 443 2 2002 AAP2 44 22 TARGET3 2 D001 PXX2 56 224 2 D002 PXX3 666 332

3 Answers   IBM, Mphasis,

---

What do you understand by SOA of Informatica?

0 Answers  

---

write sql query following table quarter sales q1 1000 q1 2000 q1 3000 q1 4000 q2 5000 q2 6000 q2 7000 q2 8000 q3 1000 q3 2000 q3 3000 q3 4000 q4 5000 q4 6000 q4 7000 q4 8000 i want the output format like q1 q2 q3 q4 1000 5000 1000 5000 2000 6000 2000 6000 3000 7000 3000 7000 4000 8000 4000 8000

5 Answers   CTS,

---

without using emailtask how will send a mail from informatica?

3 Answers  

---

How can you define user defied event?

0 Answers  

---

How to load last n records of file into target table - informatica

0 Answers   Informatica,

---

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

6 Answers   HCL,

---