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,

Answers were Sorted based on User's Feedback



Hi All, I've 110 records in my table but 101 records contains an error. When I run the sess..

Answer / ankit gupta

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

Is This Answer Correct ?    15 Yes 7 No

Hi All, I've 110 records in my table but 101 records contains an error. When I run the sess..

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

Hi All, I've 110 records in my table but 101 records contains an error. When I run the sess..

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

Hi All, I've 110 records in my table but 101 records contains an error. When I run the sess..

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

Hi All, I've 110 records in my table but 101 records contains an error. When I run the sess..

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

Hi All, I've 110 records in my table but 101 records contains an error. When I run the sess..

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

Hi All, I've 110 records in my table but 101 records contains an error. When I run the sess..

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

Post New Answer

More Informatica Interview Questions

Hi If i had source like unique & duplicate records like 1,1,2,3,3,4 then i want load unique records in one target like 2,4 and i want load duplicate records like 1,1,3,3 then can any body please send me what is th scnario. my mail i shek.inform@gmail.com

6 Answers   HCL, Schneider,


How to find from a source which has 10,000 records, find the average between 500th to 600th record?

3 Answers  


Enlist the various types of transformations.

0 Answers  


Performance tuning( what you did in performance tuning)

0 Answers   Infosys,


What are the differences between joiner transformation and source qualifier transformation?

0 Answers   Informatica,






Can we use parameters of parameter file in presession command

1 Answers   Wipro,


what is mystery dimension?

1 Answers  


I have id, seq_no date, bill_amt and weight 1,11,'01-Jan-2014',100,2 2,12,'01-Jan-2014',40,5 3,13,'01-Jan-2014',32,5 4,14,'01-Jan-2014',98,2 5,15,'01-Jan-2014',105,3 6,16,'01-Jan-2014',11,3 1,11,'02-Jan-2014',40,2 2,12,'02-Jan-2014',100,5 3,13,'02-Jan-2014',132,5 4,14,'02-Jan-2014',198,2 5,15,'02-Jan-2014',15,3 6,16,'02-Jan-2014',16,3 Now I need output as date MXAMT_LSTWGHT MINAMT_GRTWGHT 01-Jan-2014 100 32 02-Jan-2014 198 100 Could not think of mapping to do so. Please help

1 Answers   Axtria,


What is the need of an ETL tool?

0 Answers   Informatica,


how will u get 1 and 3rd and 5th records in table what is the query in oracle please help me

16 Answers   Cap Gemini, IBM,


What is the Difference between sorter and aggregator?

2 Answers  


Why is meant by direct and indirect loading options in sessions?

4 Answers  


Categories