How can you complete unrcoverable sessions?
- 1 Answers
- 5663 Views
- I also Faced
- E-Mail Answers
Answer / swetha
Under certain circumstances, when a session does not
complete, you need to truncate the target tables and run the
session from the beginning. Run the session from the
beginning when the Informatica Server cannot run recovery or
when running recovery might result in inconsistent data.
| Is This Answer Correct ? | 0 Yes | 0 No |
What is informatica powercenter repository?
How to extract the informatica rejected data?
hi all hi have flat file like below my requirement is empid,ename,sal,loc 101,vamshi,5000,hyd 101,vamshi,5020,hyd 201,raju,5000,hyd 202,ram,4000,hyd 203,kumar,3500,pune 203,kumar,3500,pune 203,kumar,5000,hyd 203,kumar,6000,hyd i want the o/p like this in one target 201,raju,5000,hyd 202,ram,4000,hyd and in second target 101,vamshi,5000,hyd 101,vamshi,5020,hyd 203,kumar,3500,pune 203,kumar,3500,pune 203,kumar,5000,hyd 203,kumar,6000,hyd
What happens if you increase commit intervals and also decrease commitExplain grouped cross tab?
what is bitmap index? did u use it?and how to use it in informatica
i have f;latfile source. i have two targets t1,t2. i want to load the odd no.of records into t1 and even no.of recordds into t2.
What is a look up function? What is default transformation for the look up function?
Can any one describe what is audit table briefly?how does it look like and what are the columns in it?
Hi Every One,What is Use of Factless Fact Table ? Why we use Factless Fact Schema in the Projects waiting for reply? thank you
I have in my source Records like 100,101,102 etc. I have router transformation which has groups like one group is empno=100, second group is empno>99. Now i want to know my source record 100 loads into which group?
i have flatfile source. i want to load the maximum salary of each deptno into target. what isthe mapping flow
What are the session parameters?
Teradata 
