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
- 16531 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
Why update strategy and union transformations are active? Explain with examples.
Explain load alternative records / rows into multiple targets - informatica
What are the designer tools for creating transformations?
What is meant by a domain?
Describe an informatica powercenter?
What is the procedure for creating independent data marts from informatica 7.1?
Explain how many types of dimensions are available in informatica?
In warehouses how many schemas are there?
What does reusable transformation mean?
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
What are mapplets? How is it different from a Reusable Transformation?
What is joiner change?
Enterprise data warehouse your projects phase by phase explain?
How does a sorter cache works?
