how do u use sequence created in oracle in informatica?
Explain with an simple example
Answer Posted / kishore
Using SQL transformation we can call the sequence in
informatica.
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What are the advantages of informatica?
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
How to Create a folder using pmrep command?
explain one complex mapping with logic? sales project?
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
What are the different clients of powercenter?
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?
What is an unconnected transformation?
What the difference is between a database, a data warehouse and a data mart?
Explain load alternative records / rows into multiple targets - informatica
Explain the informatica workflow?
How to convert multiple rows to single row (multiple columns) in informatica
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.
How can a transformation be made reusable?
Explain the different lookup methods used in informatica?