what is the diff b/w target load plan and cbl?
Answer Posted / brahmareddy
cbl specifies the load order in to the number of targets based on primarykey and foreign key.this is vary useful when you r loading data in to snowflake dimentions.
target load order species the order in which data extract from sq tr
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Explain pushdown optimization and types in informatica
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
How would you join a node to the already existing domain?
Please let me know how to make Data masking in informatica..
What is substr in informatica?
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
Where can we find the throughput option in informatica?
Enlist the tasks for which source qualifier transformation is used.
What is the sql query overwrite in source qualifier in informatica
Name the different lookup cache(s)?
Write the prerequisite tasks to achieve the session partition?
How to create the source and target database connections in server manager?
what is the -ve test case in your project.
draw informatica architecture 8.6 ?
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?