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?
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 |
Suppose in the next version of Informatica, RTR Xn is excluded. Then how will u route data to different tgts?
My i/p is 1,2,3,4,5,6,7,8,9,10……….. o/p to be populate in two tables as below. o/p1: 10,20,30,40,50,60,70,80,90……. o/p2: 11,21,31,41,51,61,71,881,91…….
In development project what is the process to follow for an etl developer from day1
How many number of sessions can one group in batches?
What are the issues you have faced in your project? How did you overcome those issues?
Update strategy transformation is an active transformation.How it changes the number of records that pass through it? Please explain....
What is lookup change?
we have to use order by,where,having we to implement sql query
What are the different options available for update strategy?
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
How did you handle performance issues If you have data coming in from multiple sources, just walk thru the process of loading it into the target
In pmcmd command we need to type -p:password. Will it be visible to others who is having access to this file ?