How can we use external procedural logic in informatica?
No Answer is Posted For this Question
Be the First to Post Answer
list the transformation used for the following:Heterogeneous sources,Homogeneous sources,Find the 5 highest paid employees with in a dept,create a summery table,generate surrogate keys
explain the methodology of Data Warehousing?(Polaries)
how does the server recongnise the source and target databases.Elaborate on this
Give a way in which u can implement a real time scenario where data in a table is changing and u need to look up data from it.How will u configure the look up transform for this purpose?
List few etl bugs?
what are the reports created in mm and sd side using sap bw in a project? name some of them and explain the requirement?
how do u set partition points in the mapping?
can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.
What is partitioning? Explain different types of partitioning?
where is the cache (lookup, index) created and how can you see it.
what are the different Reporting and ETL tools available in the market?
How can you use an Oracle sequences in Informatica ? You have an Informatica sequence generator transformation also. which one is better to use?