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
- 16339 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 delete duplicate row using informatica?
Is there any target staging area in informatica not staging area
What is the need of an ETL tool?
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
How to convert multiple rows to single row (multiple columns) in informatica
What is domain in terms of informatica?
What is the maplet?
What are the differences between joiner transformation and source qualifier transformation?
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
Briefly define a session task?
what is size of u r database?
How do you load only null records into target? Explain through mapping flow.
What is meant by active and passive transformation?
What is meant by pre and post session shell command?
How to create the source and target database connections in server manager?
