Answers were Sorted based on User's Feedback
Answer / krishna
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
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 ?||4 Yes||0 No|
Answer / aswin
Its purely depending on the way the design involved..Recovery strategy is not possible with flatfile targets..If commit happens inbetween, there is no point in running session from beginning
so manual intervention is required to restat the flatfile target load fails
|Is This Answer Correct ?||1 Yes||0 No|
Answer / seshagiri k
by removing the target table and run the session again
if it is wrong pls send the answer to my mail
|Is This Answer Correct ?||0 Yes||0 No|
Explain about Recovering sessions?
What is the Difference between SetVariable and setmaxvariable in informatica?
TELL ME ABOUT WORK FLOW SCHEDULING?
How to identify this row for insert and this row for update in dynamic lookup cache
what is scd?
tell me the push down optimization
what is the logic will you implement to laod the data in to one factv from 'n' number of dimension?
When do you use mapping parameters? (In which transformations)
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…….
I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.
HOw can we load the normalised data ( Vertical data) to (Horizontal data)with out using decode in the expression transformation and the aggregator transformation. But, what exactly I want is .. If we have million of records,it is not possible using decode and search for that Particular Id to pivot into Horizontal data... Can any one of guys please help me in this regard.....
can u any challenge your project?