Interested to Buy Any Domain ? << Click Here >> for more details...
when i was running the seesion, after loading 100 records,
session suddenly fails.Next time i want to load the remaing
rows in target with out truncate target table.What should i
use?
- 7 Answers
- 17128 Views
- Cegedim, IBM, TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / bsgsr
hi, suresh,
go for session recovery if you run in normal mode.
if it is a bulk mode session only option is to truncate the
table and run the session again.
| Is This Answer Correct ? | 23 Yes | 1 No |
Answer / raveendra g
By using Performance recovery option we can close this
issue.
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / rakhee
Try using mapplet variable
It helps to load data in the part.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / powerstar
session recovery works much better if it is run in normal mode.
If the load type is bulk mode, then session recovery is compromised.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / krishna
gayathri,
if you work in the same manner probably there is a chance
of record duplicates to be loaded if you restart the session
| Is This Answer Correct ? | 1 Yes | 2 No |
Answer / gayathri
Go to workflow manager. choose mapping. There u uncheck the
box truncate table. This shd. load ur remaining rows
without truncating the previously loaded records.
| Is This Answer Correct ? | 1 Yes | 11 No |
WE HAVE 10 RECORDS IN SOURCE IN THAT GOOD RECORDS GO TO RELATIONAL TARGET AND BAD RECORDS GO TO TARGET FLAT FILE ? HERE IF ANY BAD RECORDS MEANS ITS LOAD INTO FLAT FILE AND SEND AN EMAIL , IF NO BAD RECORDS MEANS NO NEED TO SEND EMAIL . PLZ HELP ME ...
Can we create a node as a gateway node and the same node can be assigned to a grid?
In real time scenario where can we use mapping parameters and variables?
What is different between the data warehouse and data mart?
in unconnected lookup , what are the other transformations , that can be used in place of that expression transformation ?
How we can create indexes after completing the loan process?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
what is the drillup & drill down?and use of the drill up and drill down?
Explain informatica architecture - version 8 / 9
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
a soure table has 100 records how to load into 3 target tables in a cumulative order source target1 target2 target3 --------- ------------------------------------- 1-100 1 2 3 4 5 6 - - - 98 99 100
can u give example for factless fact table
Teradata 
