The reject rows say for example due to unique key constrain is all pushed by session into the $PMBadFileDir (default relative path is <INFA_HOME/PowerCenter/server/infa_shared/BadFiles) which is configured with path at Integration Service level. Every Target will have property saying Reject filename which gives the file in which rejects rows are stored.
How to add a number to a macro variable?
Code the tables statement to produce a multi-level frequency?
How to CREATE an external dataset with sas code?
What is option year cuttoff in sas?
Suppose date is 05sep2005; i want the output like 05sep2005000000 ; how it will come?
Suppose a null dataset with 10 variables; i want to print only name of the varibales in log window and also output window. How can we do this one?
What is the use of catalog?
Suppose a dataset with 100000 records. i want 100 records from that dataset and create a dataset.we need to pick the observations random order like100obs,500obs,1020obs,1890obs,2565obs like that i need 100 obs in random order? how can we create this one?
What is validvarname and varnum? why we are using this options; explain with a syntax for this options?
In PROC PRINT, can you print only variables that begin with the letter “A”?
rendc.org
Whether it is technological solutions or user-oriented innovations, We have put together for you the best sources of HR Interview Questions and Answers, Tech Ideas, and Programming Tutorials."
Get all the latest information on rendc.org
© 2022 | All rights reserved.
RENDC
welcome to www.rendc.org
