Answer / kunkala.ramakrishna

ETL:- ETL MEANS FIRST EXTRACT DATA FROM SOURCES AND TRANSFORMS DATA FOR DESIGNED FORMAT THEN LOAD THE DATA IN TO TARGET

IN THIS ETL THE DATA MOVING 2 TIME IN THE NETWORK
1 SOURCE TO STAGGING
2 STAGGING TO TARGET

ELT: ELT MEANS FIRST EXTRACT THE DATA FROM SOURCES AND LOAD IN TO TARGET THEN TRANSFORM DATA FOR DESIGNED FORMAT

HERE DATA FIRST LOAD IN TEMPERY TABLES AFTER TRANSFORM THE DATA THEN LOAD IN TO PERMENT TABLES

IN THIS ELT THE DATA MOVING 1 TIME IN THE NETWORK

What are the different types of olap? Give an example?

0 Answers  

---

How to read data from flat file source if the data is in paragraph format?

2 Answers   Wipro,

---

Explain incremental aggregation in informatica

0 Answers   Informatica,

---

case and like function in informtica (my source is XML). case when OS Like'%Windows%' and OS Like '%200%' then 'Windows 200' case when OS Like'%Windows%' and OS Like '%200%'and OS like '%64%' then 'windows 200 64 bit' etc.,,

1 Answers  

---

How to load the data from people soft hrm to people soft erm using informatica?

0 Answers  

---

---

What are the tasks that Loadmanger process will do?

1 Answers  

---

My source has 100 records. I have targets say in number 5. all target tables has parent and child relationships in between themselves. Now I want to load all 100 records into all targets. How U can ensure that record inserted in parent and then loaded into child.

3 Answers   Cognizant,

---

Plz can any one say me how to get the informatica certification materials and dumps

0 Answers   TCS,

---

What is difference between a connected look up and unconnected look up?

6 Answers  

---

Source as 1 1 2 2 3 3 How to get target as 1 2 3 and 1 2 3

3 Answers   CTS,

---

what are the output files that the informatica server creats during running a session?

2 Answers   CTS,

---

How an expression transformation differs from aggregator transformation?

0 Answers  

---