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
- 16816 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
What is a repository? And how to add it in an informatica client?
What is Data Caches size?
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
What is lookup transformation?
can we override a native sql query within informatica? Where do we do it?
Enlist the differences between database and data warehouse.
What are active transformations.
How to implement security measures using repository manager?
While migrating the data from one environment to another environment how would you manage the connections?
scenario where i can use only concurrent execution of workflow.
Explain the difference between a data warehouse and a data mart?
How we can use union transformation?
Design a mapping to load a target table with the following values from the above source?
Is there any way to read the ms excel datas directly into informatica?
Can we override a native sql query within informatica?
