how to load dimension table and fact table. plz tell me the
steps.
No Answer is Posted For this Question
Be the First to Post Answer
my source having 10 records but how can i load 20 records in target, i am not bother about duplicates?
what is constraint based load order
How do you load only null records into target?
What are the different types of olap? Give an example?
Diffrence between static and dynamic cache
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
Hi I have two sources like A, B. My source A contain 10000 million records from that i need 20 attributes. My source B has also same 10000 million records from that i need only 1 attribute. By using Joiner i have to load into target? Is there any issue regarding this? if issue is there how to tune this mapping in best way?
when i try to connect to the repository server i am getting this message can someone help me.. Starting Repository [infa_rep] (6016|1292) Informatica Repository Agent, version [7.1.1], build [0811], 32-bit. (6016|1292) Copyright (c) 2000-2004 Informatica Corporation. All Rights Reserved. This Software is protected by U.S. Patent Numbers 6,208,990; 6,044,374; 6,014,670; 6,032,158; 5,794,246; 6,339,775 and other U.S. Patents Pending. (6016|1292) Informatica Repository Agent starting up. (6016|1292) Security audit trail has been turned off. (6016|1292) infa_rep: Repository runtime manager initialized. (6016|1292) infa_rep: Initialized configuration information. (6016|1292) infa_rep: Initialized request dispatcher. (6016|1292) Database Connection Error : Failed to logon to Database server ORA-12154: TNS:could not resolve service name Database driver error... Function Name : Connect Database Error: Failed to connect to database using user [] and connection string []. (6016|1292) Service stopped.
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
Which transformation can be created only as reusable transformation but not as non-reusable transformation?
how much memory (size) occupied by a session at runtime
What will happen when Mapping variable and Mapping parameter is not defined or given? Where do you use mapping variable and mapping parameter?