| Other Informatica Interview Questions |
|| Asked @
|what is diffrence b/w joner and union transfermation
|I want skip first 5 rows to load in to target? what will be
the logic at session level ??
|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.
|What is a diff between joiner and lookup transformation
|How IN function works in informatica? Is it similar that of
oracle IN function or different? Explain
|Is snow flake or star schema used?
If star schema means why?
|THREE DATE FORMATS R THERE . HOW TO CHANGE THESE THREE INTO
ONE FORMAT WITHOUT USING EXPRESSION TRANSFORMATION ?
|Hi All, i have question regarding Change Data Capture in
Informatica. As i know we can do this using Incremental
Aggregation(i never worked on Informatica but i read) and i
think we can do the same with SQL Over write and with
variables. Can someone tell me how do we do this using
other two techniques.. using SQL Over write and variables.
Thanks for the help and greatly appreciated.
|How can u stop a batch?
|what happens if you try to create a shortcut to a non-
|If you want to create indexes after the load process which
transformation you choose?
|What are the types of groups in Router transformation?
|For more Informatica Interview Questions Click Here |