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
- 16586 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 the different lookup cache(s)?
What are ETL Tools?
How to do the error handling of if ur source is flatfiles?
According to his methodology what all you need before you build a datawarehouse
Why update strategy and union transformations are active? Explain with examples.
Why is sorter an active transformation?
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
How can we use mapping variables in informatica?
Could you explain what is enterprise data warehouse?
What are session parameters ? How do you set them?
can we override a native sql query within informatica? Where do we do it?
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
What is the maplet?
What is Session and Batches?
