Interested to Buy Any Domain ? << Click Here >> for more details...
There are two file are there .1st file contains 5 records and
2nd file contain 10 records in target they want 50 records.how
can achieve this
- 5 Answers
- 11666 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / bharath
Use query
>select * from tab1,tab2;
You get Cartesian Product of two table rows
if tab1 having m no.of an tab2 has n no of col
then mXn (m by n) rows are returned.
| Is This Answer Correct ? | 10 Yes | 2 No |
Post New Answer View All Answers
Describe the main features of datastage?
Why fact table is in normal form?
Demonstrate experience in maintaining quality process standards?
What is a folder? Difference types of stages?
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)
Differentiate between validated and Compiled in the Datastage?
Hi , Can anyone give few examples of scenarios and there corresponding design in datastage..i am new to this tool...confused in design while my manager asking to design the job.. Please post the URL if there..so i can go through it.. Thanks in advance...
What is "fatal error/rdbms code 3996" error?
Difference between in process and inter process?
What are orabulk and bcp stages?
What are the various kinds of the hash file?
Hi guys, Please design a job for dis requirement with derivation(solution). my source table like dis. emp_no qualification 1 a 1 c 2 a 3 c 3 b To loaded to target like dis emp_no qualification 1 b 2 b 2 c 3 a my requirement is every employer have three qualifications i.e a,b and c. what qualification missed in source table that will be move to target systems. Hope u got it the requirement. Right Thanks.
Describe the architecture of datastage?
What is the difference between operational data stage (ods) and data warehouse?
CHANGE CAPTURE
