how will u load the data to diminision tables and fact tables,what is the hiraraichy why we are using hirarichy

2 Answers   TCS,

---

can you use flat file for lookup table?why?

2 Answers   HCL,

---

What do you mean by DTM and Load manager and what is difference between load manager and load balancer?

0 Answers  

---

what is lookupoverriding?

1 Answers  

---

How did you handle performance issues If you have data coming in from multiple sources, just walk thru the process of loading it into the target

1 Answers  

---

How would you join a node to the already existing domain?

0 Answers  

---

What is informatica etl tool?

0 Answers  

---

What is meant by target load plan?

0 Answers  

---

source table have 3 records? and it is sucessfully loaded into target. and 4more records is added in to source .that means 7 records now in source. we have to load the remaining 4 records into the same trgt table with maintian top 3 records. how ?can any one give me the data flow of this logic plz?

5 Answers   Wipro,

---

my source having the records like ram 3 sam 5 tom 8 and i want to load into target like ram record 3 times,sam record 5 times, tom record 8 times

3 Answers   Satyam,

---

Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.

0 Answers   IBM,

---

What is the difference between Active and Passive transformation?

0 Answers   Informatica,

---