I have file with empid,empname and I want to load these two
fields along with sal in my target
1)salary must be same for all the records
2)I want pass the salary at run time
Answer Posted / sirisha
by using transformer stage also we can generate the column &
values also
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
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)
What are the differences between datastage and informatica?
How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?
Define Data Stage?
What all the types of jobs you developed?
What is the process of killing a job in datastage?
How to find value from a column in a dataset?
What is the flow of loading data into fact & dimensional tables?
What is the purpose of interprocessor stage in server jobs?
What is the difference between operational data stage (ods) and data warehouse?
What are stage variables, derivations and constants?
how can we create rank using datastage?what is the meaning of rank?
What is the use of hoursfromtime() function in transformer stage in datastage?
How to convert RGB Value to Hexadecimal values in datastage?
What are the various kinds of the hash file?