i have one table with one column in this column i have three
rows like 1,1,2 then that rows populate to target as first
tow rows as one row and remaing row as one row how it posible?
COLUMN_NAME
SHIVA
RAMU
MADHU
THEN I WANT TO LIKE SHIVA AND RAMU IN ONE ROW AND
MADHU IS ONE ROW IF ANY ONE KNOW PLZ TELL ME
Answer Posted / prasad
Question is not clear.
U want 1,1 records goes to one target and duplicate records goes to another target, is it right? can u plz conform this and just let me know?
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the use of datastage director?
What are the various kinds of containers available in datastage?
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)
how to implement scd2 in datastage 7.5 with lookup stage
What can we do with datastage director?
whom do you report?
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)
disign the complex job in u r project?(they are aksing only complex job design and then data flow...)
How to implement complex jobs in data stage?
What are the functionalities of link partitioner?
What all the types of jobs you developed?
What all are the different way to run a job?
Which commands are used to import and export the datastage jobs?
What is the difference between server job and parallel jobs?
What are the steps needed to create a simple basic datastage job?