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

in which situations do u go for snowflake schema ?

2 Answers   TCS,

---

what is the diff b/w union and joiner and lookup?

4 Answers  

---

Clarify the utilization of aggregator cache record?

1 Answers  

---

what type of documents you receiving from client later wt can you do? what type of documents have to prepare?

2 Answers   CGI,

---

following scenario i have 1000 record flatfile source i want ist row to ist target 2nd eow to 2nd target 3rd row to 3rd target how will u do?

7 Answers   Polaris,

---

What are the join types in joiner transformation?

1 Answers   Informatica,

---

What is metadata reporter?

1 Answers   Informatica,

---

Whether Aggrigator transformation ignore the null values or consider the null values ? Advance Thanks, Manojkumar

3 Answers   IBM,

---

Performance tuning( what you did in performance tuning)

1 Answers   Infosys,

---

Why use shortcuts(Instead of making copies).

1 Answers  

---

,if we have single SQ in flow and we have router in which it has two group and we want to join these two groups with joiner ?is it possible?

3 Answers   Emphasis,

---

difference between shortcut and reusable transformation?

2 Answers  

---