Answer / ankit gupta

set commit interval as 100 in WF session and commitType as
target

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.

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,

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.

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

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;

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

What are the types of lookup?

3 Answers   Wipro,

what is the hint? how to use it to reduce the query processing in program?

3 Answers   Cegedim,

why do we go for update strategy tr in SCD rather using the session properties?

3 Answers   IBM,

wt is the difference between truncate and delete in which situation u use delete and truncate in real time..

4 Answers   TCS,

why we use informatica in our project?

2 Answers   TCS,

How IN function works in informatica? Is it similar that of oracle IN function or different? Explain

2 Answers   Mphasis,

How to update source definition?

0 Answers  

What is the difference between procedure and stored procedur?

2 Answers   IBM,

How do you set a varible in incremental aggregation

0 Answers  

What are the designer tools for creating tranformations?

1 Answers   Informatica,

who to split dimentions into sub dimention

3 Answers   Wipro,

If there are 3 workflows are running and if 1st workflow fails then how could we start 2nd workflow or if 2nd workflow fails how could we start 3rd workflow?

4 Answers   TCS,