Interested to Buy Any Domain ? << Click Here >> for more details...
how can we generate row values like
1
1
1
2
2
2
3
3
3
using col generator
plz let me know
- 2 Answers
- 8591 Views
- I also Faced
- E-Mail Answers
Answer Posted / peeyush sehgal
Take input file like 0 1 2 3 4 5 6 7 8 9
seq -> trans -> seq
in transformer, clear its partitioning and sort the data.
then in stage variable
initialize sv=1
if inputlink%3=0 then sv+1 else sv
populate sv in output column.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
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
State the difference between an operational datastage and a data warehouse?
what is flow of project?
How we can covert server job to a parallel job?
What is the purpose of pivot stage?
Name the different types of Lookups in Datastage?
What is use Array size in datastage
what is the use of materialized view?
What is the difference between server job and parallel jobs?
how do u catch bad rows from OCI stage? And what CLI stands for?
Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.
What are the difference types of stages?
Define Merge?
Differentiate between Join, Merge and Lookup stage?
What is merge stage?
