How can write SQL Overwrite to get Daynamic rows from the source in SQ transformation!(Any Example)

1 Answers  

---

Can u access a repository created in previous version of Informatica?

0 Answers  

---

A mapping contains source table S_Time(stat_year,end_year) target table TIM_DIM(date,day,month,year,quarter) stored procedure transformation: A procedure has two parameters I_end_year and output parameter as O_date ,day , month, year, quarter, If this session is running, how many rows will be available in the target and why?

0 Answers  

---

How can we handle Rejection Logic in Source tables while we are matching the data in Target side in ETL Testing ?

2 Answers  

---

If you concatenate data from a normalizer transformation,the ports you concatenate cannot include OCCURS(T/F).

1 Answers  

---

what is the meant by Normalization and de-normalization?

2 Answers  

---

we hava more than 1000 records. i have to select first 5 record, last 5 record and 5 records from middle of the source. how can i do in oracle as well as in informetica??

4 Answers  

---

Hi, can anyone plz share the project architecture for etl testing(banking domain) plz explain the architecture .

0 Answers   Cap Gemini,

---

What is full load & incremental or refresh load?

0 Answers  

---

List few etl bugs?

0 Answers  

---

What are the new features of informatica 9 version?

2 Answers  

---

What are snapshots? What are materialized views & where do we use them? What is a materialized view log?

0 Answers  

---