Answer Posted / lokesh
first we need to converted flat files in tables ofter join
the oracle and that table
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE
Notification Activity
A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?
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 orabulk and bcp stages?
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
On which interface you will be working as a developer?
What are stage variables and constants?
How do you remove duplicate values in datastage?
What is oci?
What are the functionalities of link partitioner and link collector?
In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?
Could anyone give brief explanation bout datastage admin
How to find value from a column in a dataset?
What are the some differences between 7.x and 8.x version of datastage?