Informatica Interview Questions
Questions Answers Views Company eMail

how can we perform incremental aggregation?explain with example?

IBM, TCS,

9 20778

How can i catch the Duplicate Rows From SorterTrans in a Seperate Target Table ?

2 7362

Can you please mail me a copy of Informatica Certification Exam dumps to r_balakrishna@yahoo.com

21 21692

Please explain in detail with example about 1.Confirmed Dimension. 2.Junk Dimension. 3.Degenerated Dimension. 4.Slowly changing Dimensions

Infotech,

3 6827

Please explain in detail with example about 1.Confirmed Dimension. 2.Junk Dimension. 3.Degenerated Dimension. 4.Slowly changing Dimensions

IBM, Infotech,

4 34611

Why we need XMLs?

IBM,

3 6675

What is ThroughPut in Informatica, How it works, Where I can find this option to check ?

CTS,

5 43330

Dependecy Errors in Informatica ? Do u got any dependency problems while running session? Can any one Explain Clearly.

CTS,

2 8076

LOOKUP Condition is nothing but a Join condition? What type of join condition it,by default ? Using the LookUP Condition How many types of relational conditions we can make ?

6 20937

How many mapplets u have created? and what is the logic used

Mind Tree,

5 10176

why do we go for update strategy tr in SCD rather using the session properties?

IBM,

3 15629

How to transform normalized data to denormalized form in informatica? Is there any logic or any transformations to achieve this?

3 27366

How/where can i install Informatica software with oracle or teradata as database

1941

Informatica software installation 8.1/7.1.3/7.1 with oracle 10g database (optional Teradata v2R6)

1 4318

There are n numbers of flatfile of exactly same format are placed in a folder .Can we load these flatfile's data one by one to a single relational table by a single session??

TCS,

9 11828


Post New Informatica Questions

Un-Answered Questions { Informatica }

What are the validations that you can perform in oracle and in informatica ? Advance Thanks

1634


if we have a delimiters at unwanted places in a flat file how can we over come those.

1538


What are the types of data warehouses?

923


What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?

1162


How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.

1310






Explain scd type 3 through mapping.

557


What are the types of schemas we have in data warehouse and what are the difference between them?

503


What is a code page?

690


What are ETL Tools?

647


is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?

602


Differentiate between router and filter transformation?

591


in reporting we add some new objects,how we get the count of the newly added objects to the report

1729


What are the tasks that source qualifier perform?

614


How do you set a varible in incremental aggregation

1419


Explain about Informatica server process that how it works relates to mapping variables?

600