How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
1016How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
637I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
641
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
What do the PUT and INPUT functions do?
Explain what are the vaious etl tools in the market?
Informatica server and client are in different machines. You run the session from the server manager by specifying the source and target databases. It displays error . You are confident that everything is correct. Then why it is displaying the error?
What sort of existing documents should business analysts refer to when starting on a new project?
What are the various types of transformation?
How can I remove header from output data set?
What is the roundrobin collector?
5. How many repositories can we create in Informatica? 6. What is surrogate key? 7. What is difference between Mapplet and reusable transformation? 8. What is aggregate awareness? 9. Explain reference cursor? 10. What are parallel querys and query hints? 11. DWH architecture? 12. What are cursors? 13. Advantages of de normalized data? 14. What is operational data source (ODS)? 15. What is meta data and system catalog? 16. What is factless fact schema? 17. What is confirmed dimension? 18. What is the capacity of power cube? 19. Difference between PowerPlay transformer and power play reports? 20. What is IQD file? 21. What is Cognos script editor? 22. What is difference macros and prompts? 23. What is power play plug in? 24. Which kind of index is preferred in DWH? 25. What is hash partition? 26. What is DTM session? 27. How can you define a transformation? What are different types of transformations in Informatica? 28. What is mapplet? 29. What is query panel? 30. What is a look up function? What is default transformation for the look up function? 31. What is difference between a connected look up and unconnected look up? 32. What is staging area? 33. What is data merging, data cleansing and sampling? 34. What is up date strategy and what are th options for update strategy? 35. OLAP architecture? 36. What is subject area? 37. Why do we use DSS database for OLAP tools?
What is the difference in the way microstrategy handles custom group and consolidations?
What is the difference between one to one merge and match merge? Give an example.
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
what is degenerated dimension?
Tell me what is full load & incremental or refresh load?
Explain difference between powerplay transformer and power play reports?