In what scenario we use to improve session performance by pushdown optimization?can any one give example?
- 2 Answers
- 5266 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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
| Is This Answer Correct ? | 0 Yes | 0 No |
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
| Is This Answer Correct ? | 0 Yes | 0 No |
How many types of sessions are there in informatica.please explain them?
How can we use batches?
What is Performance tuning in Informatica?
I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?
what is semi-additive fact?where did u used?
Define Update Override?
sir presently i am persuing my m.tech recently i got job in tcs as fresher presently iam doing my 9 months project related to informatica can any one guide me how to create fact tables what type of schemas must be used and so on if so give ur mail ids so that i can contct through it
In EMP table, for those emp whose Hiredate is same, update their sal by "sal+500" or else for others keep the sal as it is, how to do it by SQL query
When you move from devel to prod how will you retain a variable
What is polling?
how can we perform incremental aggregation?explain with example?
Using Connected or unconnected lookup for performance wise which one is preferable?.
Teradata 
