Answer / srinath.p

Push down Optimization is the great option provided by
informatica powercenter. this senario is used in both source
and targets are databases

Answer / jaspreet banga

One can push transformation logic to the source or target
database using pushdown optimization. The Integration
Service translates the transformation logic into SQL
queries and sends the SQL queries to the source or the
target database which executes the SQL queries to process
the transformations. The amount of transformation logic one
can push to the database depends on the database,
transformation logic, and mapping and session
configuration. The Integration Service analyzes the
transformation logic it can push to the database and
executes the SQL statement generated against the source or
target tables, and it processes any transformation logic
that it cannot push to the database.

just consider the example:----

Suppose a mapping contains a Filter transformation that
filters out all employees except those with a DEPTNO
greater than 40. The Integration Service can push the
transformation logic to the database. It generates the
following SQL statement to process the transformation logic:

INSERT INTO EMP_TGT(EMPNO, ENAME, SAL, COMM, DEPTNO)
SELECT
EMP_SRC.EMPNO,
EMP_SRC.ENAME,
EMP_SRC.SAL,
EMP_SRC.COMM,
EMP_SRC.DEPTNO
FROM EMP_SRC
WHERE (EMP_SRC.DEPTNO >40)
The Integration Service generates an INSERT SELECT
statement and it filters the data using a WHERE clause. The
Integration Service does not extract data from the database
at this time

How to recover the standalone session?

2 Answers  

---

Hi I have two sources like A, B. My source A contain 10000 million records from that i need 20 attributes. My source B has also same 10000 million records from that i need only 1 attribute. By using Joiner i have to load into target? Is there any issue regarding this? if issue is there how to tune this mapping in best way?

2 Answers   Zensar,

---

Hi 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....

1 Answers  

---

How to generate or load values in to the target table based on a column value using informatica etl tool.

0 Answers   Informatica,

---

What are the circumstances that infromatica server results an unreciverable session?

1 Answers  

---

who to split dimentions into sub dimention

3 Answers   Wipro,

---

Hi, I have one flatfile as target in a mapping . When i am trying to load data second time into it. The records already is in flatfile is getting override. I don't want to override existing records. Note : we can do this by implementing CDC / Incremental pool logic if target is relational . But this is flatfile. So, even i use this same technique it will override only So what is the solution ? Is there any option at session level for flatfile target ? Advance Thanks

4 Answers   IBM,

---

where does the default group roew in a router is stored what is the default size of memory in router

1 Answers  

---

Please let me know how to make encryption and decryption with example?

0 Answers  

---

i want to load data in to two targets..one is dimension table and the other is fact table?how can i load ata a time

3 Answers   iGate,

---

On lookup on any table we can get only a)any value or b)last value but if i need both duplicate values How can i achieve?

3 Answers  

---

in static and dynamic which one is better

2 Answers  

---