What are the types of data that passes between informatica
server and stored procedure?
Answer / swetha
3 types of data
Input/Out put parameters
Return Values
Status code.
| Is This Answer Correct ? | 4 Yes | 0 No |
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 are the out put files that the informatica server creates during the session running?
In dimension and fact table? which one holds big data?
How to eliminate 1st and last rows from the source and load the inbetween rows.
How are the sources and targets definitions imported in informatica designer?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
Explain direct and indirect flat file loading (source file type) - informatica
Hi all, i am new to this site and new to Informatica too. I have few questions regarding that. 1) When we load flat files into target tables how do we identify duplicates? and where do load the duplicate records for further reference? 2) How do we do chage data capture? Is this Slowly changing Dimension technique? Thanks in Advance
What are the databases that informatica can connect to windows?
what is the diff b/w target load plan and cbl?
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.
How to load relational source into file target?