Interested to Buy Any Domain ? << Click Here >> for more details...
HOW CAN WE ABORT THE JOB IF THE RECORDS OF SOURCE FILE
CONTAINS VALUE AS 'VIJAY'?
- 1 Answers
- 10410 Views
- Infosys, I also Faced
- E-Mail Answers
Answer / d anil babu
hi this is anil.
seqfile---->transformer----->dataset
in transformer take constrain and in that ename=vijay and give
value 1 abort after rows in consrain window
| Is This Answer Correct ? | 16 Yes | 0 No |
how can i abort the job if i get more than 100 errors in job log?
1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.
What is the default padding character?
CAN WE DECLARE DATASET SET WITH OTHER THAN .DS EXTENTION OR NOT IF YES WHAT IS THE DIFFERENCE U FIND?IF NOT WHY?
Why do we use link partitioner and link collector in datastage?
how to export or import the jobs in .ISX file
Explain usage analysis in datastage?
when we have to go for a sequential file stage & for a dataset in datastage?
What is a delta record? How you will read it?
What is the difference between operational data stage (ods) and data warehouse?
INPUT file 'A' contains: 1 2 3 4 5 6 7 8 9 10 input file 'B' contains: 6 7 8 9 10 11 12 13 14 15 Output file 'X' contains: 1 2 3 4 5 Output file 'Y' contains: 6 7 8 9 10 Output file 'Z' contains: 11 12 13 14 15 How can we implement this in a single ds job?
HOW CAN YOU DO SCD2 IN DATA STAGE USING SEQUENTIAL FILES?
Teradata 
