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 |
how can we check whether a particular cache is static or dynamic?
Enlist the tasks for which source qualifier transformation is used.
Explain about HLD and LLD ?
suppose i have 1000 records and i want to load half of the record in target 1 and half in target2.how u'll do?
what is the size of u r source(like file or table)?
tell me the push down optimization
Load data to multiple targets according date. When First time session runs it should send to 1st target,second time session runs then send to 2nd target and goes on how to achieve it
I have a scenario like - how can i load 1st record to Trgt1,2nd->Trgt2, 3rd->Trgt3 and again the cycle has to repeat with loading 4th->Trgt1,5th->Trgt2,6th->Trgt3?
what is pre and post sql and what is diff between source presql and target pre sql
write sql query following table amount year quarter 1000 2003 first 2000 2003 second 3000 2003 third 4000 2003 fourth 5000 2004 first 6000 2004 second 7000 2004 third 8000 2004 fourth i want the output year q1_amount q2_amount q3_amount q4_amount 2003 1000 2000 3000 4000 2004 5000 6000 7000 8000 can anybady help me to achieve the aboue result by using informatica. thanks in advance.
Hi Experts, Performance Wise Which transformation is better in LOOKUP AND JOINER TRansformations? Why? Can anybody please explain it ? Please help me out from this Question. Thanks In Advance.
In real time scenario where can we use mapping parameters and variables?