Answer Posted / pavani
parameter set means we are design one job inthat job we are
using local variables are global variables on that time we
are declared the parameter set(this is used for that
particular job or whole project also we are used.
ex just we want load dept=10 taht means 10 dept details only
we are loading target table on that we used paramterset
,another ex is just i want see dept no 30 records only on
that time also we are using parameterset.
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
What is oci?
What are the main features of datastage?
Describe stream connector?
How do y read Sequential file from job control?
1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)
Difference between in process and inter process?
Explain Quality stage?
What is the difference between informatica and datastage?
how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara
how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)
How to read multiple files using a single datastage job if files have the same metadata?
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
How to reverse the string using unix?
Name the command line functions to import and export the DS jobs?
How do you start developing a datastage project?