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
- 14909 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 |
two tables from two different databases r there . both having same structure but different data . how to compare these two tables ?
Write a query to display Which deptno is containing highest Sal > avg (sum (Sal)) of all deptno; Avg (sum (Sal)) o f all deptno= 9675 Deptno, sum (Sal) 10 8750 20 10875 30 9400
Is it passive or active when check and uncheck the box of DISTINCT in Sorter transformation? why?
6 Answers iFlex, Morgan Stanley,
Hi I'm new in Informatica. Can you show me a mapping sample on how to piviot the records? Thanks Robin
I HAVE A SOURCE FILE CONTAINING 1|A,1|B,1|C,1|D,2|A,2|B,3|A,3|B AND IN TARGET I SHOULD GET LIKE 1|A+B+C+D 2|A+B 3|A+B WHICH TRANSFORMATION I SHOULD USE
What is IQD file?
How to do Half of the table ex: if 1000 records are there means 500 in one table and 500 in second table like this if N number of tables means how to do Half of the table ??????????
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
Hi I have two sources like A, B. My source A contain 10000 million records from that i need 20 attributes. My source B has also same 10000 million records from that i need only 1 attribute. By using Joiner i have to load into target? Is there any issue regarding this? if issue is there how to tune this mapping in best way?
what is mean by flag 4 in update strategy t/r
How to configure mapping in informatica?
How to recover the standalone session?
Teradata 
