Interested to Buy Any Domain ? << Click Here >> for more details...
What are set operators in Oracle
- 3 Answers
- 17144 Views
- Deloitte, Wipro, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
How will restrict values in 0-9 and A-Z and a-z and special character.Only allowed these chars otherwise we will reject the records? what is the function we used to restrict...
Do you have to change the reject file b4 using reject loader utility.
Suppose we have a (assume relational) source table Product_Id Month Sales 1 Jan x 1 Feb x . . . . . . 1 Dec x 2 Jan x 2 Feb x . . . . . . 2 Dec x 3 Jan x 3 Feb x . . . . . . 3 Dec x . . . . . . and so on. Assume that there could be any number of product keys and for each product key the sales figures (denoted by 'x' are stored for each of the 12 months from Jan to Dec). So we want the result in the target table in the following form. Product_id Jan Feb March.. Dec 1 x x x x 2 x x x x 3 x x x x . . So how will you design the ETL mapping for this case , explain in temrs of transformations.
Differentiate between Load Manager and DTM?
what is sql override?what is the use of it?
What is the Hierarchy of DWH?
How can you join two tables without any common column present in them?
What is dynamic cache?
What are set operators in Oracle
why we are using level option in normalizer transformation
Enterprise data warehouse your projects phase by phase explain?
When i run workflow first session runs 4 times 5th time 2nd session must run? How can u do?
Teradata 
