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?
Answer Posted / devi
CREATE TABLE B
AS
SELECT * FROM A
ORDER BY ROWNUM DESC;
Is This Answer Correct ? | 26 Yes | 4 No |
Post New Answer View All Answers
Explain about Informatica server process that how it works relates to mapping variables?
What are the popular informatica products?
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
How does the aggregator transformation handle null values?
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
Explain pushdown optimization $pushdownconfig parameter - informatica
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
What are the informatica performance improvement tips
What is the way to execute pl/sql script using informatica mapping?
How to use procedural logic inside infromatica?
permutations of mapplet
Where do we use mapping variables in informatica?
how to load dimension table and fact table. plz tell me the steps.
Why update strategy and union transformations are active?
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?