Informatica Interview Questions
Questions Answers Views Company eMail

how many repositories can v create in informatica .

Cap Gemini, Tech Mahindra,

3 13244

Can anyone give some input on "Additional Concurrent Pipelines for Lookup Cache Creation" ? I know that this property is used to build caches in a mapping concurently. But which values should I set into this ( i.e. 1 or 2 or 3 or something else ) for concurrent cache building ?

Wipro,

1 20943

If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b,the target shd be loaded as 1 a+b+c or 1 a||b||c, what transformations shd be used for this?

CTS, Wipro,

3 12387

How can one know that a table has indexes and is partitioned? How data will be pulled from Partitions in Oracle for Informatica?

1 3486

When to use normalization transformation other than cobol source?

2 5940

i have a source which relational.I am trying to populate to target flat file with one column for daily date which is sysdate. I want to populate the sysdate coulmn with DD/MM/YYYY format. kindly provide a solution for this..my clear that my target is flat file.

3 5837

How to join a Flat and Relational Source without using (Joiner, Update and Lookup ) transformations... is it possible? if yes i would like to know how?

Wipro,

10 22782

What is the difference between a table and the materialized view?

2 7421

What is the difference between bitmap and btree index?

CTS, TCS,

2 8951

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

2060

I have a flat file, in which i have two fields, emp_id, emp_name. The data is like this, emp_id,emp_name 101,soha 101,ali 101,khan 102,siva 102,shanker 102,reddy. how to merge the names so that my output is like this Emp_id Emp_name 101 Soha ali kahn 102 siva shenkar reddy please provide solution

5 9113

I want to get an license to produce excel format output using informatica tool. Anyone help me in this issue. Thanks in advance, Vishnuvardhan

1 3869

Could anyone please mail me a copy of Informatica Certification Exam dumps to sandeep.nakka@gmail.com it would be appreciated if any one could help me out.

1771

what is shortcut in informatica? difference between shortcut,reusable object?

Virtusa,

2 15067

What will happen if we have a filter transformation used in a mapping and in the filter condition we specify 1. Yes nothing else, only the number 1. In other words, assuming we have 10 rows coming to this filter transformation as an input, how many rows will be output by this transformation when we have only 1 in the filter condition?

TCS,

5 18346


Post New Informatica Questions

Un-Answered Questions { Informatica }

Explain lookup transformation in informatica

650


What are the differences between joiner transformation and source qualifier transformation?

628


What do you mean by blocking transformation?

585


How many numbers of sessions can one group in batches?

625


What is lookup transformation?

602






can any one give some examples for pre sql and post sql(Except dropping and creating index).

3514


What are the tasks that source qualifier perform?

633


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

618


explain one complex mapping with logic? sales project?

6154


Explain the scenario which compels informatica server to reject files?

658


What are the different clients of powercenter?

602


What are the steps involved in the migration from older version to newer version of Informatica Server?

1585


how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process

1699


What is joiner transformation?

585


How to extract sap data using informatica?

607