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 settings that you use to configure the joiner transformation?
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
How would you join a node to the already existing domain?
can u give example for factless fact table
explain about unit testing? in real time?
How can a transformation be made reusable?
Explain what is informatica metadata and where is it stored?
How will the document be delivered to me?
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
how tokens will generate?
What are the static cache and dynamic cache in informatica?
How can we improve session performance in aggregator transformation?
What all are steps in up gradation of Informatica server?
What are Dimensional table?