I have Seq file, I don't want 10, 11th(or any two records like 20, 30th records ) records in the output
Answer Posted / subhash (subbuchamala)
If we use @INROWNUM, then we have to run transformer on 'single' NODE.
| Is This Answer Correct ? | 8 Yes | 0 No |
Post New Answer View All Answers
If you want to use a same piece of code in different jobs, how will you achieve this?
How to read multiple files using a single datastage job if files have the same metadata?
What is the difference between the local container and shared container?
EXPLAIN SCD
What is a ds designer?
explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?
What are the functionalities of link partitioner?
What is orabulk stage?
Could anyone give brief explanation bout datastage admin
What are the benefits of datastage?
Differentiate between datastage and datastage tx?
How many types of hash files are there?
How we can covert server job to a parallel job?
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.
DB2 connector> transformer > sequential file Data will be exported into a csv format in a sequential file. This file will be send in a email using a sequence job. Problem here is, how to avoid sending a blank csv file? When I ran the job there are chances that it might return zero records but in the sequence job csv file is going blank. how can I avoid this? thanks