Answer Posted / hemanth

Please send the informatica dump to my mail id
hemanth.gorur@gmail.com

What is grain of fact?

900

---

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

1804

---

Hi Guys, my requirement is to load 1 yr data from oracle to teradata database through abinitio etl graph.i need to schedule this as a monthly job.but i want to load 12 month data for the first time and from second time it should load last (recent) month data and delete 13th month data. For example For the first time it should load 201208 to 201108 data, second time it should delete 201108 month data and load 201209 month data. I developed garph to load 12 month data ,but i don't know how to handle above requirement as am new to abinitio. i greatly appreciate you help.Thank You.

2155

---

What is cube grouping?

996

---

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?

1821

---

what are the types in error loging?

2091

---

how do u estimate the depth of the session scheduling queue? Where do u set the number of maximum concurrent sessions that Informatica can run at a given time?

1955

---

What is virtual Data Warehousing?

925

---

how many steps are there in etl process?

919

---

when will use SQL override in a lookup transformation?

2229

---

SCD2 will work on only dimension tables as well as fact Table?

1344

---

Is apache nifi an etl tool?

910

---

what is granularity in Data ware House?

1654

---

What is a materialized view log?

948

---

what is the meaning of upgradation of Repository?

3693

---