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
- 16508 Views
- Tech Mahindra, I also Faced
- E-Mail Answers
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 use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
How to do unit testing in informatica? How to load data in informatica ?
How to go to the older version for a mapping?
While migrating the data from one environment to another environment how would you manage the connections?
What is the difference between stop and abort in informatica
What are the differences between joiner transformation and source qualifier transformation?
What is parallel processing in informatica?
what is size of u r database?
What is the sequence generator transformation in informatica?
What is the need for an etl tool?
How can we use batches?
What is informatica powercenter repository?
What is the format of informatica objects in a repository?
What are mapplets?
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
