What are the types of metadata that stores in repository?
Answers were Sorted based on User's Feedback
Answer / mahesh
Following r the types of metadata that stores in the
repository
Database connections
Global objects
Mappings
Mapplets
Multidimensional metadata
Reusable transformations
Sessions and batches
Short cuts
Source definitions
Target definitions
Transformations
| Is This Answer Correct ? | 6 Yes | 1 No |
Answer / usha
Repository which is used to store metadata...
Metadata is nothing but ..
1:-structure of the source table and target table..
2:-mapping
| Is This Answer Correct ? | 1 Yes | 1 No |
What is status code in informatica?
What is the use of target designer?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
How to create a mapping ? id date 101 2/4/2008 101 4/4/2008 102 6/4/2008 102 4/4/2008 103 4/4/2008 104 8/4/2008 O/P - shud have only one id with the min(date) How to create a mapping for this
Explain in detail scd type 2 through mapping.
which one is costliest transformation? costliest means occupying more memory. which one Aggregator,sorter,filter,etc..
You have defined the following: - Commit Type = 'Target' - Commit Interval = 10000 - writer buffer block can hold multiple 7,500 rows - you are loading 40,000 records into the target After how many records will the Informatica Server issue commit commands? a)7500, 15000, 22500, 30000, 40000 b)15000, 22500, 30000, 37500, 40000 c)15000, 22500, 30000, 40000 d)15000, 30000, 40000
How to go to the older version for a mapping?
what are the limitations of pushdown optimization technique ? Advance thanks
Can we use unconnected lookup as dynamic lookup?
5 Answers ITC Infotech, TCS, Wipro,
how do u move the code from development to production?