Follow Our FB Page << >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

Informatica Interview Questions
Questions Answers Views Company eMail

What is the Hierarchy of DWH?

1 6272

How many repositories can we create in Informatica?

3 6318

What is surrogate key?

9 20241

What is difference between Mapplet and reusable transformation?


9 37574

What is aggregate awareness?

1 8084

Explain reference cursor?

1 7817

What are parallel querys and query hints?

1 6583

While importing the relational source defintion from database,what are the meta data of source U import?

1 4102

Howmany ways yoU can update a relational source defintion and what are they?

1 4232

Where should yoU place the flat file to import the flat file defintion to the designer?

4 7984

To provide support for Mainframes source data,which files r used as a COBOL files

1 2972

Which transformation should u need while using the cobol sources as source defintions?

2 3474

How can yoU create or import flat file definition in to the warehouse designer?

2 6645

what is a transforamation?

5 4635

What are the designer tools for creating tranformations?


1 4167

Post New Informatica Questions

Un-Answered Questions { Informatica }

what are the best practices to extract data from flat file source which are bigger than 100 mb memory?


What is standalone command task?


What are the tasks that source qualifier perform?


What is the need of an ETL tool?


What is pmcmd command?


CANNOT USE PARAMETER FILE! Hi all, I am trying to use parameter file for my workflow. This could help me to filter records where CITY = 'Portland' Following is what I have done: **in Designer - create new parameter : $$PARA_FIL, Parameter, String, IsExprVar=TRUE, Initial value = [empty] - Source Qualifier/ Properties/Source Filter: CUSTOMERS.CITY='$$PARA_FIL' **Create Parameter file: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt $$PARA_FIL='Portland' **Configure workflow to use the parameter file: Edit Workflow/Properties/Parameter Filename: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt I also configured directory of parameter file for session task. However, I just got this in the session log: [SQ_CUSTOMERS] SQL Query [SELECT CUSTOMERS.CUSTOMER_ID FROM CUSTOMERS WHERE CUSTOMERS.CITY='$$PARA_FIL'] No record has been loaded to target. It seems that the parameter file has not been read. I cannot understand the reason why. Could any of you kindly suggest me anything? Thanks


Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.


How many transformations can be used in mapplets.


What is data movement mode in Informatica and difference between them?


Define joiner transformation?


I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.


Explain joiner transformation in informatica


I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?


What are the features of complex mapping?


How can we improve session performance in aggregator transformation?