Interested to Buy Any Domain ? << Click Here >> for more details...
if the session fails after 100 records agian we have to
starts the
session or we go for recovery session
- 2 Answers
- 10276 Views
- TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / guest
informatcia server has 3 methods to recovering the
sessions.
1)Run the session again if the Informatica Server has not
issued a commit.
2)Truncate the target tables and run the session again if
the session is not recoverable.
3)Consider performing recovery if the Informatica Server
has issued at least one commit.
Use performing recovery to load the records from where the
session fails.
| Is This Answer Correct ? | 10 Yes | 0 No |
Answer / rekha
U CAN GO FOR PERFORMACE RECOVERT ,IF THE SERVER PERFORMS
ATLEAST ONE COMMIT
| Is This Answer Correct ? | 2 Yes | 1 No |
Hi, In source I have records like this No name address 10 manoj mum 10 manoj dilhi 20 kumar usa 20 kumar Tokyo I want records in target like shown below No name addr1 addr2 10 manoj mum dilhi 20 kumar usa Tokyo If it is reverse we can do this by using Normalizer transformation by setting occurance as 2. Somebody will say use denoralization technique. But as of my knowledge I couldn’t find any denormalization technique. Is there any concept like that? I tryid this seriously but I could find any idea to implement this. Can any one please help me ? Advance Thanks
If a table contains 100 records we have to fetch 50-100 records from source to target?how
Explain where to store informatica rejected data? How to extract the informatica rejected data?
What is data movement mode in Informatica and difference between them?
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
What is a parameter When and where do you them when does the value will be created
for ex: in source 10 records are there with column sal. use a filter transformation condition as Sal=TRUE and connect to target. what will happen.
I HAVE 10 records in source. I want to store i record in target 1, second record in target 2, third record in target 3, 4 th record again in target 11, 5th again in target 2, 6th again in target3 etc.... how it is possible?
What is meant by lookup transformation? Explain the types of lookup transformation?
what happens when a batch fails?
What are the different versions of informatica?
source table have single column single record having with single space. load that source record into trg . trgt having two columns and the SOURCE TABLE LIKE COL1 BHANU PRASAD TRGT TABLE COL1 COL2 IN THAT LOAD THE RECORD IN THE trgt table LIKE COL1 COL2 BHANU PRASAD HOW ? TELL ME PLZ
Teradata 
