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,
Answer Posted / 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 |
Post New Answer View All Answers
How to update source definition?
How do you take back up of repository?
Different sorts of metadata that stores in the storage facility?
What is a filter transformation?
define galaxy repository in informatica
The question was on time stamp. what is the difference between HH and HH24 when to use when.
can anyone explain me about retail domain project in informatica?
How will the document be delivered to me?
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
Explain the etl program with few examples.
What are the advantages of informatica?
What is transformation?
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
Explain load alternative records / rows into multiple targets - informatica
What are multi-group transformations?