How many repositories can we create in Informatica?
Answer Posted / jagan
unlimited repositories
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
How you prepared reports for OLAP?
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
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.
Explain sessions?
How to improve the performance of a session using sorter transformation?
What are the features of complex mapping?
Explain the informatica workflow?
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
Explain the features of connected and unconnected lookup.
While importing the relational source definition from the database, what are the metadata of source that will be imported?
What is the scenario which compels informatica server to reject files?
Different circumstance which drives informatica server to expel records?
What is a standalone command task?
expain about the tune parameters?
What the difference is between a database, a data warehouse and a data mart?