If I have a index defined on target table and if set it to
bulk load will it work ?
Answers were Sorted based on User's Feedback
Answer / parikhita prusty
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,Normal load supports index.
Is This Answer Correct ? | 21 Yes | 0 No |
Answer / 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 |
Answer / babu
Hi Frnds,
Bulk load support if the target has index.but u have to
disable the ENABLE PARALL MODE OPTION in the connection
object tab.
Navigation:
WrkflowManager==>connections(Tab)==>Relationalconnection==>
Objects==>object name==>Edit==>Attributes==>Enable Parallel
Mode(check box)
By default it was enabled.
Thanks &Regards
Babu
8861145051
Is This Answer Correct ? | 3 Yes | 0 No |
Answer / parikhita prusty
BULK LOAD DOESN'T SUPPORT THE INDEX.BULK LOAD BY PASSES LOG WHICH WE CAN'T RECOVER THE SESSION WHEN SESSION FAILS.MOSTLY WE USE INDEX FOR SELECT STATEMENT WHICH INCREASES THE PERFORMANCE WHEN WE INSERT THE RECORDIN A TABLE HAVIN INDEX IT DECREASES THE PERFORMANCE.SO BEFORE INSERT THE DATA IN THE TABLE WE HAVE TO DROP OR DISABLE THE INDEX WHICH INCREASES THE PERFORMANCE.NORMAL LOAD SUPPORT THE INDEX.
REGARD'S
PARIKHITA
Is This Answer Correct ? | 0 Yes | 0 No |
disable caching in a lookup transformation?
What is the difference between writing a joiner query in ANSI style and THETA style?
There are 3 groups in router transformation in which there are no conditions mentioned, so what happens if I connect these groups to the 3 targets? How many records gets into each target.(suppose if we are getting 10 records from the source)
IN A MAPPING WHEN WE USE AGGRIGATER TRANSFORMATION WE WILL USE GROUP BY PORT. IF GROUPBY IS NOT SELECTED BY DEFAULT IT WILL TAKE ONLY THE LAST COLUMN WHY????
Q. source having mutile depatment of data, dept1, dept2 ....dept10 today. we have mutilple depts in source, we need to generate dept1, dept2 and multile files in target side. today we have 10 dept which have 10 files, tommorow we have only 4 dept and 4 files, dayafter tommorow we have only 6 all the number of files in the targete file directory it's always dynamic. how can acheive it.
why normalizer transformation can not used in mapplet? plzzzz answer
How to read data from flat file source if the data is in paragraph format?
Explain the flow of data in Iinformatica?
Let’s say I have more than have record in source table and I have 3 destination table A,B,C. I have to insert first 1 to 10 records in A then 11 to 20 in B and 21 to 30 in C. Then again from 31 to 40 in A, 41 to 50 in B and 51 to 60 in C……So on up to last record.
What are the different threads in DTM process?
what is confirmed dimension?
If source is having 5000 rows,and if you want to load data into 500 rows to target,if the session runs successfully,how can you verify the target if the rows are successfully loaded or not.