where actually the usage of push down optimization
happens...
Answers were Sorted based on User's Feedback
Answer / krish
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 databas
there are some limitations to it like if we are using
variable port we can't do pushdown.
Is This Answer Correct ? | 4 Yes | 0 No |
Answer / pradeep
Basically we use the push down optimization to reduce the load on the integration service.The integration service translate the business logic into sql query and it pushes to source & Target dbs.In this form we can reduce the load on integration.
Is This Answer Correct ? | 1 Yes | 0 No |
Differnce between filter and router?
What is the difference between normal and bulk loading? Which one is recommended?
How can you display only hidden files in UNIX
how can we check whether a particular cache is static or dynamic?
What will happen when Mapping variable and Mapping parameter is not defined or given? Where do you use mapping variable and mapping parameter?
differnece between joiner and a look up(please don't give just definitions)....i mean in which scenario it is better to use joiner and in which scenario better o use lookup ??
I have 1 crore record in my table and I have to load 25 L in 1st target,25L in 2nd target and 25L in 3rd target? I am new to Informatica,can anybody suggest me the idea?
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
in what type of scenario bulk loading and normal loading we use?
what is normalizer transformation?
TELL ME ABOUT WORK FLOW SCHEDULING?
How union transformation is active ?