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
- 14422 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
As union transformation gives UNION ALL output, how you will get the UNION output?
What are the restrictions of union transformation?
How to handle decimal places while importing a flatfile into informatica?
Explain sessions?
What are the tuning techniques you applied during your last project
How would you join a node to the already existing domain?
What is informatica etl tool?
How do you manage the Parameter files while migrating your data from one environment to another environment?
What will be the approach?
Explain in detail about scd type 1 through mapping.
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
Where are the source flat files kept before running the session?
According to his methodology what all you need before you build a datawarehouse
I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.
What is Cognos script editor?
