Technical Interview Questions and Answers :: Informatica

Home > Technical Interview Q&A > Informatica > Q & A

Upcoming !!!

1 / 94

What is CDC and How have you applied CDC technique?

View Answer| Post Your Answer | my reading list

To Reading List | tag

Asked In

Answer:

CDC stands for Change data capture. it means some changes in the source side.

Please Login First :

2 / 94

Without using update strategy trns how do we do insert update.

View Answer

BEST PHP Interview Questions With A...

BEST PHP Interview Questions With Answers - PHP Interview Questions For Beginners and Experienced

| Post Your Answer | my reading list

To Reading List | tag

Asked In

Answer:

Session properties - enable treat all rows as insert.

Target properties - enable update else insert.

Please Login First :

3 / 94

Debug option in informatica(to find out which transaction has failed).

View Answer| Post Your Answer | my reading list

To Reading List | tag

Asked In

Answer:

Informatica Designer Provide the option called Debugger

Please Login First :

4 / 94

Session statistics(without checking the logs to find out which session has failed and where)

View Answer| Post Your Answer | my reading list

To Reading List | tag

Asked In

Answer:

No Discussion on this question yet!

Please Login First :

5 / 94

Can session be run without workflow.

View Answer| Post Your Answer | my reading list

To Reading List | tag

Asked In

Answer:

No, Sessions cannot be executed independently, a session must be added to a workflow.

Please Login First :

6 / 94

Why scd2? can we do insert update in scd1 and how?(what if we have a new record and our mapping is scd1)

View Answer| Post Your Answer | my reading list

To Reading List | tag

Asked In

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

Oracle question: Difference in view and materialized views? Have you used views or synonyms?

View Answer| Post Your Answer | my reading list

To Reading List | tag

Asked In

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

Difference in instance and database.

View Answer| Post Your Answer | my reading list

To Reading List | tag

Answer:

No Discussion on this question yet!

Please Login First :

9 / 94

Do you know any other design than star or snowflake schema. If we do not want to use both then what to use and how.

View Answer| Post Your Answer | my reading list

To Reading List | tag

Asked In

Answer:

No Discussion on this question yet!

Please Login First :

10 / 94

Which all transaction have sql option.

View Answer| Post Your Answer | my reading list

To Reading List | tag

Asked In

Answer:

No Discussion on this question yet!

Please Login First :

Technical Interview Questions and Answers :: Informatica

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.

info@q4interview.com

JaipurChalo.com

CrackExams.in

eWritingCafe.com

FitYoga.in

SarkariResultInfo.net

Off-Campus Placement News

Technical Interview Questions and Answers :: Informatica

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.

Technical MCQs