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 source one table is there. id value --- ------ 1 a 2 b 3 c 1 d 2 e 1 f in target i want id value ---- ------ 1 a,d,f 2 b,e 3 f How to implement it in informatica without using normalizer transformation?

2 Answers   IBM,

---

What do you mean by channel change?

0 Answers  

---

When the informatica server marks that a batch is failed?

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,

---

How to load time dimension?

1 Answers   Ford,

---

---

Hi ETL gurus can any one tell me with a flow how to implement SCD Type 1 and SCD Type 2 in a single mapping.For some fields SCD type has to be implemented and for some fields scd type has to be implementd..Thank in advance..please let me know in case of any concerns...

1 Answers  

---

Explain about Recovering sessions?

1 Answers  

---

what is degenerated dimension?

1 Answers   IBM,

---

What do you mean by filter transformation?

0 Answers  

---

suppose i have 1000 records and i want to load half of the record in target 1 and half in target2.how u'll do?

9 Answers   IBM,

---

In a table, 4 person having same salary. How to get Third person record only?

15 Answers  

---

How we will implement Pushdown Optimization and Types in Informatica with better examples

4 Answers   TCS,

---