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
- 6181 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 to get max value record into one target and remaining records into another target?
what is rank and dense rank in informatica with any examples and give sql query for this both ranks
1)What is Data Masking in informatica? 2)How to restrict junk characters while loading data into target. 3) what happen if i won't pass sorted input in a transformation.
how will u get 1 and 3rd and 5th records in table what is the query in oracle please help me
How to import oracle sequence into Informatica?
How to prepared lld.can any one tell me detailed explanetion.
How do you avoid duplicate records with out using source qualifier,expression,aggrigator,sorter and lookup transformations ?
If we have 1000 rows were loaded in to datawarehouse and next day the source have 1010 rows so, how can we loaded only updated rows into target.
1)how to generate sequnce numbers in informatica without using sequnce genarator transformation. 2)i have number of records in my sourse, but iwant to display first and last record only. how it is possible in informatica. 3)i want to update the records without using updatestrategy transformation. 4)what is diffrance between ab-intio and datastage than compared to informatica. 5)what is the latest version of informatica in our field.
whatis the default data driven operation in informatica
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
wht is cdc?how to use it in creation of mappings?
Teradata 
