Follow Our FB Page << CircleMedia.in >> 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?

Wipro,

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?

Informatica,

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?

1462


What is standalone command task?

184


What are the tasks that source qualifier perform?

189


What is the need of an ETL tool?

186


What is pmcmd command?

139






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

6373


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

685


How many transformations can be used in mapplets.

987


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

196


Define joiner transformation?

155


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.

794


Explain joiner transformation in informatica

167


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?

853


What are the features of complex mapping?

147


How can we improve session performance in aggregator transformation?

208