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).

For stage table data processing, suppose in first run we processed 8 records out of 10 records then in 2nd run we should consider only not processed records (here total no of records =2) along with new records which got loaded in stage table thru real time mapping. Note : In this example, 8 records are those records for which we got transaction number after lookup on trn_no_cod table and 2 records for which lookup returns trn_no as NULL

1 Answers  

---

CAN WE IMPLEMENT SCD TYPE 1 AND SCD TYPE 2 IN SAME MAPPING? IF SO HOW?

6 Answers  

---

how do u move the code from development to production?

3 Answers  

---

Explain dynamic target flat file name generation in informatica

0 Answers   Informatica,

---

whether Sequence generater T/r uses Caches? then what type of Cache it is

7 Answers   Accenture,

---

what is mean by throghput? in informatica

3 Answers   Cap Gemini,

---

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

2 Answers  

---

Normalizer transformation is not involved in Mapplet.. why???

1 Answers   Wipro,

---

What is the way to execute pl/sql script using informatica mapping?

0 Answers  

---

I have a source either file or db table Eno ename sal dept 101 sri 100 1 102 seeta 200 2 103 lax 300 3 104 ravam 76 1 105 soorp 120 2 Want to run a session 3 times. First time: it should populate dept 1 Second time: dept 2 only Third time: dept 3 only How can we do this?

2 Answers   TCS,

---

Can we override a native sql query within informatica?

0 Answers  

---

4 yrs etl devloper roles and responsibilities?any body give solutions

0 Answers   TCS,

---