What are two examples of an OLTP environment?
Answers were Sorted based on User's Feedback
Answer / prasoon
On Line Banking
On Line Reservation(Transportation like Rail, Air etc.)
| Is This Answer Correct ? | 20 Yes | 2 No |
Answer / aneesh raj
ATM(Automated Teller Machine)
On Line Reservation
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / vivekk
any technical process which has the front end and back end used for business transaction purpose are the examples of OLTP.
Frond end can be designed in any language (java, c, .net, etc...)
Back end should be the database (db2, oracle, Teradat, etc...)
Examples of OLTP, i will go with the above commented posts.
| Is This Answer Correct ? | 0 Yes | 0 No |
If the table does not have duplicates then which utility you can suggest to load the data ?
i have a table like sales....the field are Prodid Jan(jam month sales)Feb March 1 20 76 50 2 30 94 40 3 40 90 30 4 70 20 30 5 23 40 40 6 85 30 55 7 84 20 65 8 10 93 40 9 57 30 30 10 38 83 40 11 35 39 90 12 83 89 50 Now the Question is i want get the max sales of 12 products from the months.hint:for eg I WANT GET 89 for product12... Can any one help me
IBM QUESTION As all we know PE takes the SQL Request and it will give responce for that query. what is the internal process happening.how it is taking that sql from the system????? thanks in Advance
2 Answers Cap Gemini, IBM, Infosys,
I have a employee table with EMPID, EMPNAME, DEPTID, SAL and want to fetch the maximum and minimum salary on each dept id with the emp name. Can anyone help in this? The result should contain the EMPNAME, DEPTID, SAL.
Hello all, There is a table with 4 columns in that 3 columns has been already loaded with 5 million records.4th column is empty,Now I have got 5 million records data which has to be loaded into 4th column.How can I load this data fastly in to the 4th column with out using update
Why AMP & PE are called Vprocs?
Is PK concept available in Teradata. If it is how can we create Primary Key for a table in TD
What is the use of upsert command in teradata?
What is smp and mpp platforms?
What exactly do you know about catching in teradata?
Why FLOAD doesn't supports NUSI? Where as Mload supports NUSI. Please explain in this regard. Thanks in advance.
I want to load 1000 rcds using. FL for every 100 records there is a check point.But script failed at 120 records, when we are restarting the script, it starts from last ckpt, but Target table contains populated data but FL doesnt support existing data in target table. How can we load data in FL?