how lookup transformation is made active in new versions...
When to use connected and when to use unconnected lookup and why? which is good for session performance.
How to make lookup persistent and how to remove stale data from that lookup.
how commit works - when we stop or abort data. Explain in both cases.
What is factless fact table and have you ever used it in real time scenarios.
No Answer is Posted For this Question
Be the First to Post Answer
What happens if you increase commit intervals and also decrease commitExplain grouped cross tab?
What are the different types of transformation available in informatica.
how to design mapping half of source table records into one target and remaining half into another target
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance
How will u find weather dimension table is big in size of a fact table?
Explain sql transformation in script mode examples in informatica
select count(1) from emp? what is the o/p?
What is depict expression change?
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 are the types of caches in lookup? Explain them.
How to import oracle sequence into Informatica?
How to enter same record twice in the target table,explain?