| Other Informatica Interview Questions |
|| Asked @
|What is the exact difference b/w IN and EXIST in Oracle..?
|how can one come to know wether the records loak into the
target if we use update strategy
|suppose we will take flatfile target and load type is
bulkload the session fails why please give me the answer
|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 , 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
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.
|i have 1000 records in my dource table, the same i have in
target ,but a new column added in target as "batchno", and
this column adds no 10 for 1st 100 records and 20 for next
100 records and 30 next 100 records and vice versa. how to
|how to import multiple flat files in to single target where
there is no common column in the flat files
|WHAT IS THE NAME OF THAT PORT IN DYNAMIC CACHE WHICH IS USED
FOR INSERT , UPDATE OPRATION ?
|When we enable pushdown optimization technique, two options
will be enabled (use view,..). Can anyone tell me how these
two options will work ?
When do we need to go for pushdown optimization technique ?
|what is the logic will you implement to load data into a
fact table from n dimension tables?
|How to update records in Target, without using Update Strategy?
|split two strings into two columns
Source:-Full Name: Shiva Kumar
|Input flatfile1 has 5 columns, faltfile2 has 3 columns(no
output should contain merged data(8 columns)
Please let me know how to achieve ??
|For more Informatica Interview Questions Click Here |