If I have a index defined on target table and if set it to
bulk load will it work ?
- 4 Answers
- 14639 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / surya
Bulk load never support the index.so if index in target with
bulk load the session will fail.so before use bulk load u
have to drop index in target and recreate index using
target post sql
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
What are the tasks that source qualifier perform?
Slowly changing dimensions, types and where will you use them
Differentiate between a database and data warehouse?
How to improve the performance of a session using sorter transformation?
Mention some types of transformation?
How you can differentiate between connected lookup and unconnected lookup?
Is there any way to read the ms excel datas directly into informatica?
What is joiner transformation?
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.
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
What is the different lookup cache(s)?
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
What is an expression transformation in informatica?
Which version configuration tool used in ur project?
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
