1. what is load plans and types of load plans?
ANS) Load plan is a process to run or execute multiple scenarios as a Sequential or parallel or conditional based execution of your scenarios. And same we can call three types of load plans , Sequential, parallel and Condition based load plans.
2. what is profile in odi?
ANS) profile is a set of objective wise privileges. we can assign this profiles to the users. Users will get the privileges from profile. Please refer http://oditraining.blogspot.co.uk/2012/06/odi-security-manager-all-profiles.html
3 what is the odi console?
ANS) ODI console is a web based navigator to access the Designer, Operator and Topology components through browser.
4.how to write the sub queries in odi?
ANS:)Using Yellow interface and sub queries option we can create sub queries in odi.
or Using VIEW we can go for sub queries Or Using ODI Procedure we can call direct DB queries
in ODI.
5.suppose i having 6 interfaces and running the interface 3 rd one failed how to run remaining interfaces?
ANS: ) if you are running Sequential load it will stop the other interfaces. so goto operator and right click on filed interface and click on restart. If you are running all the interfaces are parallel only one interface will fail and other interfaces will finish.
6. how to remove the duplicate in odi?
ANS) Use DISTINCT in IKM level. it will remove the duplicate rows while loading into target.
7. suppose having unique and duplicate but i want to load unique record one table and duplicates one table?
ANS) Create two interfaces or once procedure and use two queries one for Unique values and one for duplicate values.
8. how to write the procedures in odi?
ANS) Procedure is a step by step any technology code operations . you can refer
ANS) Load plan is a process to run or execute multiple scenarios as a Sequential or parallel or conditional based execution of your scenarios. And same we can call three types of load plans , Sequential, parallel and Condition based load plans.
2. what is profile in odi?
ANS) profile is a set of objective wise privileges. we can assign this profiles to the users. Users will get the privileges from profile. Please refer http://oditraining.blogspot.co.uk/2012/06/odi-security-manager-all-profiles.html
3 what is the odi console?
ANS) ODI console is a web based navigator to access the Designer, Operator and Topology components through browser.
4.how to write the sub queries in odi?
ANS:)Using Yellow interface and sub queries option we can create sub queries in odi.
or Using VIEW we can go for sub queries Or Using ODI Procedure we can call direct DB queries
in ODI.
5.suppose i having 6 interfaces and running the interface 3 rd one failed how to run remaining interfaces?
ANS: ) if you are running Sequential load it will stop the other interfaces. so goto operator and right click on filed interface and click on restart. If you are running all the interfaces are parallel only one interface will fail and other interfaces will finish.
6. how to remove the duplicate in odi?
ANS) Use DISTINCT in IKM level. it will remove the duplicate rows while loading into target.
7. suppose having unique and duplicate but i want to load unique record one table and duplicates one table?
ANS) Create two interfaces or once procedure and use two queries one for Unique values and one for duplicate values.
8. how to write the procedures in odi?
ANS) Procedure is a step by step any technology code operations . you can refer
No comments:
Post a Comment