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 is mean by grouping of condition column in lookup transformation?

1 Answers  

---

If we are using an aggregator but forget to mention the group by port .what will be the output??

11 Answers   Nomura, TCS,

---

In update strategy target table or flat file which gives more performance ? why?

7 Answers  

---

How can we update a record in the target table without using update strategy?

0 Answers  

---

How i can Schdule the Informatica job in "Unix Corn Schduling tool" ?

2 Answers  

---

If sal is null then replace it with min(sal). Can any one write a query for this in oracle ? Advance Thanks

7 Answers   Puma,

---

What are the different ways to implement parallel processing in informatica?

0 Answers  

---

What is the diff. b/w informatica versions 8.1.1 and 8.6.1?

4 Answers   IBM, Wipro,

---

plz plz plz send client names and project names in informatica?

1 Answers  

---

What is version control in informatica ? Advance thanks

6 Answers   HCL, Puma,

---

When will u go for Dynamic Cache and Persistent Cache? Pls explain with an example?

2 Answers   TCS,

---

Differentiate between mapping parameter and mapping variable?

1 Answers  

---