What is the difference between Normal load and Bulk load?
Answer Posted / sachin
1.It is also not allow the constraint when we make Target load type as Bulk Mode
2.Also we do not allow to use indexes on database level in Bulk mode But in Normal mode we can allow indexes as well as constraint.
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Write the unconnected lookup syntax?
During the running session, output files are created by informatica server. Enlist few of them.
how tokens will generate?
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.
How do you load alternate records into different tables through mapping flow?
How to generate or load values in to the target table based on a column value using informatica etl tool.
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
What if the source is a flat-file?
Differentiate between sessions and batches?
Differentiate between source qualifier and filter transformation?
Please let me know how to make encryption and decryption with example?
What is confirmed fact in dataware housing?
Can we create a node as a gateway node and the same node can be assigned to a grid?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
What do you mean incremental aggregation?