Informatica Interview Questions
Questions Answers Views Company eMail

To import the flat file definition into the designer where should the flat file be placed?

Informatica,

673

How are the sources and targets definitions imported in informatica designer?

Informatica,

666

What are the data movement modes in informatica?

Informatica,

699

How to generate or load values in to the target table based on a column value using informatica etl tool.

Informatica,

607

Explain sql transformation in script mode examples in informatica

Informatica,

603

What are Dimensional table?

Informatica,

612

To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?

Informatica,

673

While importing the relational source definition from the database, what are the metadata of source that will be imported?

Informatica,

786

Explain the mapping variable usage example in informatica

Informatica,

631

Why sorter is an active transformation?

Informatica,

746

Under which circumstances, informatica server creates reject files?

Informatica,

589

Explain the pipeline partition with real time example?

Informatica,

651

What is the need of an ETL tool?

Informatica,

640

What are the types of lookup transformation?

Informatica,

629

Explain pushdown optimization and types in informatica

Informatica,

666


Post New Informatica Questions

Un-Answered Questions { Informatica }

What is meant by LDAP users?

691


What is informatica metadata and where is it stored?

582


Explain lookup transformation is active in informatica

660


Can we change Dynamic to Static or Persistent cache? If so what happens?

1726


SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N

1684






What is olap (on-line analytical processing?

639


How to load the data from people soft hrm to people soft erm using informatica?

560


Enterprise data warehouse your projects phase by phase explain?

1460


Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM

3448


What do mean by local and global repository?

701


What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?

714


What are the various types of transformation?

642


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

618


my source is junk data how will u remove that junk data by using unix please any one replay me

3239


What is depict expression change?

616