Informatica Interview Questions
Questions Answers Views Company eMail

Quickly characterize reusable change?

737

What do you mean by channel change?

589

What are the measure objects?

702

What are the different types of transformation available in informatica.

670

Explain what are the different types of transformation available in informatica.

612

What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?

652

How to do unit testing in informatica? How to load data in informatica ?

694

Explain the different dimensions.

591

Differentiate between source qualifier and filter transformation?

1045

Explain scd type 3 through mapping.

626

What is dimensional table?

660

How do you load more than 1 max sal in each department through informatica or write sql query in oracle?

1076

How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.

688

I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.

682

Explain in detail about scd type 1 through mapping.

627


Post New Informatica Questions

Un-Answered Questions { Informatica }

What are the new features of informatica 9.x in developer level?

599


What is workflow? What are the components of workflow manager?

748


Explain transaction control transformation in informatica

805


What is lookup transformation?

646


Design time, run time. If you don't create parameter what will happen

1466






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

1721


Write the advantages of partitioning a session?

789


How do you set a varible in incremental aggregation

1487


is it possible to index the data in cache of lkp transformation ?

1559


Explain dynamic target flat file name generation in informatica

682


How to use procedural logic inside infromatica?

674


What are some examples of informatica etl programs?

571


How you can differentiate between connected lookup and unconnected lookup?

653


If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me

1590


What are the types of data warehouses?

981