when load type is selected as bulk or normal in session level ?let me know the internal process and give me an example?
Answer Posted / sandeep desai
when session scheduled then load type is bulk mode at that time integration service bypass the database log file..it not create it and you cannot rollback the data
but in normal mode integration service create database log file and u can rollback the data
| Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
What do you mean by filter transformation?
pmscmd startworkflow -sv
can u give example for factless fact table
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
Parameter and variable differences
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
Quickly characterize reusable change?
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
How to implement security measures using repository manager?
Whats the difference between informatica powercenter server, repositoryserver and repository?
What is a standalone command task?
Name at least 5 different types of transformations used in mapping design and state the use of each.?
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
Difference between Target-based loading and constraint-based loading?