Answers were Sorted based on User's Feedback
Answer / siddu
For fast retrieval(to Perform a SELECT Operation)
|Is This Answer Correct ?||3 Yes||0 No|
Answer / ankit kansal
As a denormalized table structures for a database the number
of joins to fetch the data turns out to be less and hence selection to the data becomes faster.
selecting data from one table is always better than selecting the same data from multiple tables.
|Is This Answer Correct ?||1 Yes||0 No|
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
If I have router with 10 records, if the condition doesn’t satisfy the records will pass to the default group,then where can we see that records and where that records will store?
explain about session partitions ?
i having source, router transformation, two targets in my mapping... i given two conditions in router 1)sal >500 2)sal < 5000 --------------- my source is havig two sal records (1)1000 (2)2000 then which target will load first? will both targets are get load or single target only get load...... why?
What is meta data and system catalog?
In Which scenario did u used Incremental loading?
How You Pull the records on daily basis into your ETL Server.
How to elaborate powercenter integration service?
What is a surrogate key?Why we use it in a mapping?Pl give an example.
Hi gurus can any one tell me with a flow how to implement SCD Type 1 and SCD Type 2 in a single mapping.For some fields SCD type has to be implemented and for some fields scd type has to be implementd..Thank in advance....
I have source table 100 records after run session successfully but loads the target table 50 records only what happened that 50 records and how can i load remaining 50 records
what is service oriented architecture in Informatica 8 version