Interested to Buy Any Domain ? << Click Here >> for more details...
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
- 2 Answers
- 6039 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
generate date / time dimension in informatica
How to start a workflow using pmcmd command?
Can we change Dynamic to Static or Persistent cache? If so what happens?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
What is sorter transformation?
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
What is depict expression change?
Briefly define a session task?
What does update strategy mean, and what are the different option of it?
Plz can any one say me how to get the informatica certification materials and dumps
What is meant by lookup transformation?
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com
How do you load only null records into target? Explain through mapping flow.
