Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 16817 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
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
expain about the tune parameters?
What all are steps in up gradation of Informatica server?
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
tell me about your project functionality
What is meant by active and passive transformation?
Define filter transformation?
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
What is the need of an ETL tool?
What is rank transformation?
Write the prerequisite tasks to achieve the session partition?
How are indexes created after completing the load process?
Describe data concatenation?
