Hi All,
I've 110 records in my table but 101 records contains an
error. When I run the session, I want to load the 100
records into the target. Can anyone suggest me the best
solution for this...
Thanks in Advance,
- 7 Answers
- 14907 Views
- Tech Mahindra, I also Faced
- E-Mail Answers
Answer Posted / srinivas
i believe this would certainly serve your purpose.
connect your source to filter transformation. if your
source contains p_key then the condition should be
p_key<=100. if it doesnt containa a primary key ex a flat
file create a new port in the filter transformation name it
s_no and connect the nextval port of seq.gen and the
condition shud be s_no<=100 and connect to the target.
| Is This Answer Correct ? | 9 Yes | 3 No |
Post New Answer View All Answers
How to load the data from people soft hrm to people soft erm using informatica?
Suppose we do not group by on any ports of the aggregator what will be the output?
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 ?
Clarify the utilization of aggregator cache record?
expain about the tune parameters?
Why do we need informatica?
What are the differences between oltp and olap?
Explain the etl program with few examples.
What is a snowflake schema?
What do think which one is the better joiner or look up?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
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.
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
What is option by which we can run all the sessions in a batch simultaneously?
Which files are created during the session rums by informatics server?
