1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category
Informatica Interview Questions
Questions Answers Views Company eMail

How do we come to know the Source data/file is ready/Updated in the source location, when the session is scheduled for @12:00AM and ready to run its job ? or Can we schedule the session, when the source is updated in source location without any time constraint?

iFlex, TCS,

2 8256

How could we generate the sequence of key values without using sequence generator transformation in the target ??

TCS, Tech Mahindra,

12 34195

What is incremental aggregation and how it is done?

JPMorgan Chase, TCS,

8 35719

1.why we need to use unconnected transformation? 2.where we can static chach,dynamic chach

Virtusa,

4 11080

we have table like cust_id,cust_name,cust_loc like this 1.we need to get perticular location,to do this we can use filter transformatin,that logic is same for relation table and flat file tabl?

 2 5246

Plz can anybody send Informatica and Cognos FAQ Plz To thid ID ppradeep_dwh@ayhoo.co.in

 2 5507

Whatis the difference between View and Materialized View ?

Satyam, Syntel,

11 52971

Without using any transformations how u can load the data into target?

IBM,

15 20300

what is casual dimension?

IBM,

6 17173

What is a diff between joiner and lookup transformation

CTS, Satyam, TCS, UHG,

16 90735

What is difference between Informatica 6.2 Workflow and Informatica Workflow 7.1

IBM,

4 10136

Plz can anybody send Informatica and Cognos FAQ Plz To thid ID anil643@gmail.com (or) kumar643@gmail.com

 1620

Plz can anybody send Informatica and Cognos FAQ Plz To thid ID ppradeep_dwh@yahoo.co.in

1 3547

In Real Time what are the scenarios u faced, what r the tough situations u have overcome, and explain about sessions.

Cap Gemini, CTS, TCS, Tech Mahindra, Wipro,

2 22498

why cant we put a sequence generator or upd strategy transformation before joiner transformation?

Satyam,

2 16518

Post New Informatica Questions

Un-Answered Questions { Informatica }

Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?

621

waht type of interface is used for testing the data in informatica

1823

On which transformations you created partitions in your project?

750

What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?

6382

What do you mean incremental aggregation?

615




What are the types of schemas we have in data warehouse.

518

What is main use of mapplet?

644

Define the various join types of joiner transformation?

552

Whats the difference between informatica powercenter server, repositoryserver and repository?

661

Sequence generator, when you move from develoment to production how will you reset

1393

what are the deliverables?in your project?

1642

Differentiate between a repository server and a powerhouse?

565

what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?

1763

Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?

1844

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

663

For More Un-Answered { Informatica } Questions Click Here