How to recover sessions in concurrent batches?
Answer / nagaraju bhatraju
when we use concurrent process to load when session
fails ...all other session will run normally and load the
data..the failed session will considered as a standalone
sesion ...and we have perform recovery for the failed
session.
there three type where we can recover a failed session
1.start the session again if the Informatica server doesnt
perform the commit
2.else perform recovery on the session
3. if we can recover the session truncacte the data from
target table and run the session.
Is This Answer Correct ? | 7 Yes | 0 No |
tell me the push down optimization
How do schedule a workflow in Informatica thrice in a day? Like run the workflow at 3am, 5am and 4pm?
My source table look like ID Name Location Salary 1 ran NULL NULL 1 NULL DELHI NULL 1 NULL NULL 1000 I want my output to look like ID Name Location Salary 1 ran Delhi 1000 What should be my approach to design a informatica mapping. Assuming my source is flat file not a Relation table so i cant use SQL.
explain about lookup t/r?
What is difference macros and prompts?
how can send duplicate records to one tableand non duplicate records to one table with simple clear mapping?
IN SCD TYPE 1 WHAT IS THE ALTERNATIVE TO THAT LOOKUP TRANSFORMATION ?
write sql query following table pname description lux soap sunsilk shampoo lux shampoo sunsilk soap clouseup soap closeup paste i want the output like pname description lux soap sunsilk shampoo lux soap sunsilk shampoo closeup paste closeup paste
What is data merging, data cleansing and sampling?
permutations of mapplet
What is a diff between joiner and lookup transformation
16 Answers CTS, Satyam, TCS, UHG,
my source has 2 columns. 1st column data: ABC ABC ABC XYZ and 2nd column data: 1 2 3 4. And my target should be ABC 1 2 3, XYZ 4