What is power center repository?
Answer / swetha
The PowerCenter repository allows you to share metadata
across repositories to create a data mart domain. In a data
mart domain, you can create a single global repository to
store metadata used across an enterprise, and a number of
local repositories to share the global metadata as needed.
| Is This Answer Correct ? | 4 Yes | 2 No |
All active transformations r passive or not?
how do u tune queries?
What are the types of caches in lookup? Explain them.
My Source qualifier has empno, sal. Now my mapping is like SQ(EMPNO)->AGGR->EXP->TARGET SAL ------------>TARGET ? Is this mapping valid or any issues are there if we design like this?
I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.
Plz can anybody send Informatica and Cognos FAQ Plz To thid ID ppradeep_dwh@yahoo.co.in
SRC1 -> EXP -> AGGR -> TGT SRC2 -> EXP -> Above is a maaping with two pipeline connected to the taret TGT. Design wise is this design is correct or not ?
what is Partitioning ? where we can use Partition?
how do u move the code from development to production?
Update strategy transformation is an active transformation.How it changes the number of records that pass through it? Please explain....
What will happen when Mapping variable and Mapping parameter is not defined or given? Where do you use mapping variable and mapping parameter?
What are the issues u have faced in ur project? Guys pls answer to dis question.Due to this question I have failed in 3 interviews.