if u can't find what you are looking for in lookup table, how do you handle?

1 Answers  

---

how do u extract data from different data sources explain with an example?

0 Answers  

---

how do u decide whether u need to do aggregations at database level or at Informatica level?

1 Answers   QualTech,

---

can u anyone plz share some etl testing interview question . and share the sql queries and unix . plz help me to clear in the etl testing interview by sharing ur knowledge

0 Answers   Cap Gemini,

---

WHY CANT WE SEE THE DATA IN DATASET

1 Answers   IBM,

---

---

In informatica, I have 10 records in my source system. I need to load 2 records to target for each run. How do I do this?

0 Answers  

---

Two different admin users created for repository are________and_________.

1 Answers  

---

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.

0 Answers  

---

what is a parameter when and where do u them when does the value will be created. Designing time, run time. If u don't create parameter what will happen?

1 Answers  

---

What is ROWID explain ?

2 Answers   Wipro,

---

what are the facilities provided by data warehouse to analytical users?

0 Answers  

---

two sources S1,S2 containing measures M1,M2,M3, 4 dimensions D1,D2,D3,D4, 1 Fact F1 containing measures M1,M2,M3 and surrogate keys K1,K2,K3,K4 (a) write a sql statement to populate Fact table F1 (b) Design a mapping in Informatica for loading of fact table F1.

0 Answers  

---