Answer Posted / srinwanti biswas

if anyone has informatica external certification
dump...please post it to my link...
srinwanti.biswas@gmail.com

What is fact? What are the types of facts?

1117

---

what is the meant by Normalization and de-normalization?

2718

---

What is abap? What are idocs?

965

---

what is the use of structures?how many nodes can u create in a structure?

2239

---

Is hadoop a etl tool?

944

---

give detail on the sales project how many number of dimensions & fact tables are used in projec briefly. how the four fact tables taken in the project.

2362

---

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.

2213

---

What is etl process? How many steps etl contains?

1034

---

Explain about power designer data modeling software?

850

---

What is tracing level? How many types of transformations supported by sorted input?

973

---

what is data modeling?

2315

---

Assume u have a 24CPU machine with 24GB RAM, suggest how u would like to configure Informatica ,like number of concurrent sessions, RAM requirements etc,max partitions that u would permit per mapping.

1958

---

How to fine tune mappings?

941

---

What are three tier systems in etl?

1066

---

Which transformation we use to convert 'NA' to 'Not Available'

1268

---