How many concurrent programs you have customized, can you name some of them? Have to see the standra reports and possible customizations 8. How to make the project as. Applsys is a schema as apps and applsyspub. Any work done in Oracle Workflow builder. Did you customize or build a new workflow?
|Published (Last):||8 May 2019|
|PDF File Size:||16.89 Mb|
|ePub File Size:||12.52 Mb|
|Price:||Free* [*Free Regsitration Required]|
And depending on these indicators we can changes to load data successfully to target. Full Load: completely erasing the contents of one or more tables and reloading with fresh data. Incremental Load: applying ongoing changes to one or more tables based on a predefined schedule. How to determine what records to extract? When addressing a table some dimension key must reflect the need for a record to get extracted. Mostly it will be from time dimension e. Order Invoiced Stat. Foolproof would be adding an archive flag to record which gets reset when record changes.
Do we need an ETL tool? When do we go for the tools in the market? Can we use procedural logic inside Infromatica? If yes how, if now how can we use external procedural logic in informatica?
Yes, you can use advanced external transformation. Can we override a native sql query within Informatica? Where do we do it? How do we do it? Yes,we can override a native sql query in source qualifier and lookup transformation. What are parameter files? Where do we use them? Parameter file defines the value for parameter and variable used in a workflow, worklet or session.
How can we use mapping variables in Informatica? The Informatica server saves the value of mapping variable to the repository at the end of session run and uses that value next time we run the session. What is a mapping, session, worklet, workflow, mapplet? A mapping represents dataflow from sources to targets.
A mapplet creates or configures a set of transformations. A workflow is a set of instruction sthat tell the Informatica server how to execute the tasks. A worklet is an object that represents a set of tasks. A session is a set of instructions that describe how and when to move data from sources to targets. What is Informatica Metadata and where is it stored? Informatica Metadata is data about data which stores in Informatica repositories.
How do we call shell scripts from informatica? Can Informatica load heterogeneous targets from heterogeneous sources? But to join data from heterogenous source you have to use joiner transformation. What are the different Lookup methods used in Informatica? Connected lookup 2. Unconnected lookup Connected lookup will receive input from the pipeline and sends output to the pipeline and can return any number of values.
Unconnected lookup can return only one column. Active transformation can change the number of rows that pass through it. What are the modules in Power Mart? PowerMart Designer.
Oracle ETL Interview Questions and Answers
And depending on these indicators we can changes to load data successfully to target. Full Load: completely erasing the contents of one or more tables and reloading with fresh data. Incremental Load: applying ongoing changes to one or more tables based on a predefined schedule. How to determine what records to extract?
Professional Oracle D2K Interview Questions & Answers:
Kikree Change the values of hose two according to the size of the window. Templates define common characteristics and objects that can be applied to multiple reports. Sql — to format serial explain plans. What is transactional trigger property? User exits are build when ever the control need to be passed from the report builder to a program, which performs some function and then control returns to the Report Builder.
Report Triggers :-
What are referenced objects? Explain the importance of referencing. What is path setting for DLL? How is mapping of name of DLL and function done?
Oracle D2K Interview Questions and Answers
Applsys is a schema as apps and applsyspub. Any work done in Oracle Workflow builder. Did you customize or build a new workflow? Do you know table based value sets?