Hi,
I've a mapping with flat file source
The target update override property for the target table is
using update
stmt.
There is no update strategy between source and target.
Also The session has the target properties as
Insert , Update as update options checked.
Does this mean that recs will be inserted only and the
update override will
not be applied at all.
Thanks
No Answer is Posted For this Question
Be the First to Post Answer
dimension object created in oracle can be imported in designer?how?
two sources S1,S2 containing measures M1,M2,M3, 4 dimensions D1,D2,D3,D4, 1 Fact F1 containing measures M1,M2,M3 and surrogate keys K1,K2,K3,K4 (a) write a sql statement to populate Fact table F1 (b) Design a mapping in Informatica for loading of fact table F1.
What is a materialized view log?
What is fact? What are the types of facts?
what is the difference between cardinality and Nullability?
How many steps etl contains?
what are the facilities provided by data warehouse to analytical users?
how do u identify the changed records in operational data?
what make u disappointmnets in u r career
how do u estimate the number of partitions that a mapping really requires? Is it dependent on the machine configuration?
Dear All, Can anyone tell me that from where i can get Power Center 8.5 S/W for Linux and how can i install Power Center 8.5 or any 7.x series on Linux Platform. Thanks in advance
how do u automate Extraction process?