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
- 16818 Views
- Tech Mahindra, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / ankit gupta
set commit interval as 100 in WF session and commitType as
target
| Is This Answer Correct ? | 15 Yes | 7 No |
Answer / 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 |
Answer / sri
thank you for the answer, but I'm just wondering where to
write this code.
Could you let me know about the same.
Thanks,
| Is This Answer Correct ? | 5 Yes | 1 No |
Answer / jithendra
Hi,
In the session- goto Recovery strategy and then select 'Resume from last check point' it will run when the job failed at record after the next rerun it will run from the where it stopped.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / naveen
Hi Ritu,
As per my knowledge there is no property to skip the rows
in source in case of relational table.
Please let me know if am wrong.
i would go with Answer #3 given by srinivas.
Regards,
Naveen
| Is This Answer Correct ? | 0 Yes | 1 No |
Answer / cutepa1
Is this what you wanna say that 101th observation has an
error in your dataset and you wanna save those
observations(until 100th) into the target dataset. If it so,
I've an idea I think it shld help a bit.
Data nn;/* your new dataset*/
set base.agents;
/* a dataset named 'agents' that has more than 100
observations*/
if _Error_=1 then output;
/* _error_ is a PDV variable that returns '0' when there is
any error in the code and returns '1' when there is no error */
run;
| Is This Answer Correct ? | 0 Yes | 4 No |
Answer / ritu sharma
go the source and there is a property of skip the number of
rows.set it to 1 and then save the mapping and run the workflow.
Ritu Sharma
| Is This Answer Correct ? | 3 Yes | 7 No |
How will restrict values in 0-9 and A-Z and a-z and special character.Only allowed these chars otherwise we will reject the records? what is the function we used to restrict...
Kimball and Inmon methodologies?
How to enter same record twice in the target table,explain?
In a sequential batch can you run the session if previous session fails?
Can anyone know that what is the Source File limitation in Informatica? To be more precise .. how many flat file we can use as a source in a mapping if.. 1) The Structure of flat files are same & 2) If the Structure of flat files are different. Please explain the procedure also if it dosn't bother one much!!
What is Index Caches size?
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
Explain your project of banking domian.
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
What are the different types of repositories created using informatica?
How many number of sessions that u can create in a batch?
What is checksum termnology in informatica? Where do you use it ?
3 Answers Chase, Cognizant, Deloitte,
Teradata 
