Define informatica repository?
Answers were Sorted based on User's Feedback
Answer / j.david sukeerthi kumar
Hi
Informatica repository is a central meta-data storage place,
which contains all the information which is necessary to
build a data warehouse or a data mart.
Meta-data like source def,target def,business
rules,sessions,mappings,workflows,mapplets,worklets,database
connections,user information, shortcuts etc
| Is This Answer Correct ? | 15 Yes | 0 No |
How can we store previous session logs?
1)What is Data Masking in informatica? 2)How to restrict junk characters while loading data into target. 3) what happen if i won't pass sorted input in a transformation.
suppose i have source 101 a 101 b 101 c 101 d i want target like 101 abcd how will u achive this please give me the answer
How do you manage the Parameter files while migrating your data from one environment to another environment?
As union transformation gives UNION ALL output, how you will get the UNION output?
How did you handle performance issues If you have data coming in from multiple sources, just walk thru the process of loading it into the target
How to identify this row for insert and this row for update in dynamic lookup cache
one source to target loading insert new rows and update existing rows?
How informatica recognizes mapping?
what is bitmap index? did u use it?and how to use it in informatica
there is a product table prodid prodname price 100 cinthol 10 101 hamam 10 102 neem 20 103 cake 30 in the above table the price of some products are duplicated and some product prices are distinct we want to push the duplicated prices to one target and non-duplicated prices to other target without using expression and sequence generator transformation
in mapping i have one source and five targets in that data will be loaded into four targets properily in one target the data is not loaded how will u rectify