Why you use repository connectivity?
Answers were Sorted based on User's Feedback
Answer / swetha
When you edit, schedule the sesion each time, informatica
server directly communicates the repository to check whether
or not the session and users are valid. All the metadata of
sessions and mappings will be stored in repository.
| Is This Answer Correct ? | 5 Yes | 1 No |
Answer / satishkumar kundeti
When you edit, schedule the sesion each time, informatica
server directly communicates the repository to check whether
or not the session and users are valid. All the metadata of
sessions and mappings will be stored in repository.
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / ravi
The repository is a relational database that stores
information or metadata used by the informatica server and
client tools. The metadata stores the information regarding
mappings,mapplets,sessions,batches,shortcuts,source
definitions,target definitions and many more...
| Is This Answer Correct ? | 0 Yes | 5 No |
By using Transformation i need top most 5 employee salary from each deptwise? Deptno 10,20,30? which transformation we need to use?
What do you mean by blocking transformation?
How can you run a session without using server manager?
how many ways can we implement SCD2?
connected and unconnected lookups?
Can you please mail me a copy of Informatica Certification Exam dumps to sriveniv@hotmail.com
What is the surrogate key?
Consider a Phone Log table as below. It records all phone numbers that we dial in a given day. SOURCE_PHONE_NUMBER DESTINATION_PHONE_NUMBER CALL_START_DATETIME 1234 4567 01/07/2011 10:00 1234 2345 01/07/2011 11:00 1234 3456 01/07/2011 12:00 1234 3456 01/07/2011 13:00 1234 4567 01/07/2011 15:00 1222 7890 01/07/2011 10:00 1222 7680 01/07/2011 12:00 1222 2345 01/07/2011 13:00 Please provide an SQL query to display the source_phone_number and a flag where the flag needs to be set to Y if first called number and last called number are the same and N if the first called number and last called number are different. Desired Output: Source Number Is_Match 1222 N 1234 Y
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.
SOURCE NAME SAL GANGA 30000 RAJU 20000 PAVAN 25000 TARGET NAME SAL MAXSAL GANGA 30000 30000 RAJU 20000 30000 PAVAN 25000 30000 in mapping level how to achive that
i have 50500 records in my source.if wf run for the first time it will load 1000 records into 1 tgt,if runs second time it will load to another tgt.targets are FF and it is need to be created dynamically.how many tgt will be created and how?
Without using Lookup & Sequence Generator, How to generate Sequence?