in oracle write query yourname+1 from dual
Answers were Sorted based on User's Feedback
Answer / babu
it displays the error message is
"yourname": invalid identifier
| Is This Answer Correct ? | 7 Yes | 0 No |
Answer / moorthy g
It Displays the following Messages:
>> select moorthy+1 from dual
ERROR at line 1:
ORA-00904: "MOORTHY": invalid identifier
| Is This Answer Correct ? | 3 Yes | 0 No |
If one flat file contains n number records., we have to load in target from 51 to 100.. how to use expressions in Informatica..?
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
3. Suppose Seq Gen is supplying a increamental value to a column of a table, suppose, table's column value reaches to maximum value, then what will happen, will the session fail? If it is the situation, then what should be done so that we can stop this kind of situation in advance?
i have one source 52 million records i want target only 7 records ?how wil you do what logic to implement?
How to extract sap data using informatica? What is abap? What are idocs?
How many number of sessions can one group in batches?
What is union transformation in informatica?
how to get the data from the client machine and how to get server location data to client loction can any one explain bit deep please..!
What are the designer tools for creating transformations?
Please let me know how to do estimation before staring development in project. Here estimation in the sense how many associates are required, etc to complete the project.
can a port in expression transf be given the name DISTINCT
i have oracle table A and target B. i don't know how many records. i want get get last record in table A as first record in target table B. write a sql query?