Answer / hari

. Aggregator Transformations
. Sorter Transformations
. Custom Transformation
. External Procedure Transformation
. Filter Transformation
. HTTP Transformation
. Java Transformation
. Joiner Transformation
. Lookup Transformation
. Normalizer Transformation
. Rank Transformation
. Router Transformation
. Sequence Generator Transformation
. Expression Transformation
. Sorter Transformation
. Source Qualifier Transformation
. SQL Transformation
. Stored Procedure Transformation
. Transaction Control Transformation
. Union Transformation

Explain pushdown optimization and types in informatica

0 Answers   Informatica,

---

what is surrogatekey ? In ur project in which situation u has used ? explain with example ?

6 Answers  

---

What is a router transformation?

0 Answers  

---

Differences between connected and unconnected lookup?

0 Answers  

---

One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?

0 Answers   TCS,

---

Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM

1 Answers   IBM,

---

Is scd logic we have lookup right to compare the values with source and target,instead of lookup can u have any transformation or any way to do this?

2 Answers  

---

what is the difference between stop and abort?

3 Answers   TCS,

---

select count(1) from emp? what is the o/p?

5 Answers   TCS,

---

What is the difference between Normal load and Bulk load?

5 Answers  

---

PLS REAL TIMERS IAM WAITING FOR FAVOROBLE REPLY..REGARDING ETL TESTING INFORMATION...ETL TESTER NEEDS ETL DEVOLPMENT KNOWLEDGE OR NOT..?. IF HE NEED DEVLPMNT KNOW WHAT HE LEANR FIRST... AS A DEVOLOPER U KNOW THE ETL TESTING PROCESS.. PLS EXPLAIN IN DETAIL THANK U

2 Answers  

---

What is the sql query overwrite in source qualifier in informatica

0 Answers   Informatica,

---