Technical Interview Questions and Answers :: Informatica
Home > Technical Interview Q&A > Informatica > Q & A
Accenture (161)
Adobe (2)
Alcatel-Lucent (1)
Broadcom Ltd (1)
Wipro (86)
Virtusa (220)
IBM (35)
Aricent (47)
Tech Mahindra (13)
TCS (171)
Capgemini (33)
iGate (162)
Syntel Inc. (175)
AT&T (1)
Cisco (107)
Sapient (72)
Sopra Steria (138)
Societe Generale (75)
Goldman Sachs (5)
TCS NQT (7)
Huawei (11)
Wipro NLTH (36)
Paytm (67)
# C (123)
# C++ (187)
# DBMS (143)
# Soft. Engineering (77)
# Python (4)
# Finite Automata (6)
# SQL (108)
# Java (66)
# .NET (112)
# WebMethod (166)
# EDI (40)
# Informatica (94)
# Oracle Apps HRMS (106)
# Operating System (91)
# Data Structure (72)
# PHP (1)
# Unica (0)
# Oracle Apex (0)
# HR Question in TR (122)
# Networking (62)
# Hadoop (2)
# HTML (1)
# Oracle PLSQL (31)
# DPDK (Data Plane Development Kit) (40)
# Programming Qs. in TR (14)
1 / 94
|
|
|
Answer:
CDC stands for Change data capture. it means some changes in the source side.
Please Login First :
2 / 94
|
|
|
Answer:
Session properties - enable treat all rows as insert.
Target properties - enable update else insert.
Please Login First :
3 / 94
|
|
|
Answer:
Informatica Designer Provide the option called Debugger
Please Login First :
4 / 94
|
|
|
Answer:
No Discussion on this question yet!
Please Login First :
5 / 94
|
|
|
Answer:
No, Sessions cannot be executed independently, a session must be added to a workflow.
Please Login First :
6 / 94
|
|
|
Answer:
SCD2 allow keep the current and historical data in table.
SCD1 allows keep only current data. Not the historical data.
can we do insert update in scd1 and how?
Ans: Yes SC|D1 allows to insert update in data.
Please Login First :
7 / 94
|
|
|
Answer:
3 types of views
Simple,complex, m view
M views are used to increase the performance, it is like snapshot of the table. Stores result of the query
Views are virtual table, logical set of one r more tables.
Please Login First :
8 / 94
|
|
|
Answer:
No Discussion on this question yet!
Please Login First :
9 / 94
|
|
|
Answer:
No Discussion on this question yet!
Please Login First :
10 / 94
|
|
|
Answer:
No Discussion on this question yet!
Please Login First :