351. what is lookup transformation and update strategy transformation and explain with an example.Thanks in Advance

352. Is it possible to refresh the Materialized view?

353. what is difference between COM & DCOM?

354. Where we use Star Schema & where Snowflake?

355. At what frequent u load the data?

356. What is Shortcut? What is use of it?

357. COMMITS: What is the use of Source-based commits ? PLease tell with an example ?

358. What is SQL override? In which transformation we use override?

359. Can you update the Target table?

360. How to Generate the Metadata Reports in Informatica?
361. While importing the relational source definition from database, what are the meta data of source U import?
Source name Database location Column names Datatypes Key constraints

362. What is the use of incremental aggregation? Explain me in brief with an example.

363. what is difference between dimention table and fact table and what are different dimention tables and fact tables

364. how to create a custom transformation, can u give a realtime example where exactly u have used it. just give some explanation why u used the custom transformation.thx in advance


365. How do we do complex mapping by using flatfiles / relational database?

366. if source qualifier having employee details.the empid is in 5th placle and deptno is in 7th column then. u selected sort by 2. but how the informatica server will come know that those r the fields to sort.

367. What is CDC?

368. If u had to split the source level key going into two seperate tables. One as surrogate and other as primary. Since informatica does not gurantee keys are loaded properly(order!) into those tables. What are the different ways you could handle this type of situation?

369. What is the differance between Local and Global repositary?

370. what is bottleneck in informatica?

371. I am working on Infromatica. I want to do Certification in Infromatica designer. Can anybody please suggest me on how to start?

372. How can you say that union Transormation is Active transformation.

373. what is the basic language of informatica?

374. what is Partitioning ? where we can use Partition? wht is advantages?Is it nessisary?

375. how do we load data by using period dimension?

376. How can you improve the performance of Aggregate transformation?

377. why did u use update stategy in your application?

378. In update strategy target table or flat file which gives more performance ? why?

379. 1) How to load the data (like refresh load, quarterly load, hourly load etc)2) what is lookup ? (Lookup is a join is it wright or wrong)ub
380. What is the difference between materialized view and a data mart? Are they same?

381. What about rapidly changing dimensions?Can u analyze with an example?

382. Wht is incremental loading?Wht is versioning in 7.1?

383. what are the type costing functions in informatica

384. what is the repository agent?

385. what r the mapping specifications? how versionzing of repository objects?

386. Can any one please tell me the architecture of Informatica and please tell me the flow of data in Iinformatica?

387. what is the exact meaning of domain?


388. can u explain one critical mapping?2.performance issue which one is better? whether connected lookup tranformation or unconnected one?

389. can we eliminate duplicate rows by using filter and router transformation ?if so explain me in detail .

390. what are the difference between view and materialized view?

391. Differences between connected and unconnected lookup?
Connected lookupUnconnected lookup Receives input values diectly from the pipe line.Receives input values from the result of a lkp expression in a another transformation.U can use a dynamic or s

392. What is Transaction?

393. What are Data driven Sessions?
The informatica server follows instructions coded into update strategy transformations with in the session mapping to determine how to flag records for insert,update,delete or reject. If you do not ch

394. what is the architecture of any Data warehousing project? what is the flow?

395. How can I get distinct values while mapping in Informatica in insertion?

396. whats the diff between Informatica powercenter server, repositoryserver and repository?
Powercenter server contains the sheduled runs at which time data should load from source to target Repository contains all the definitions of the mappings done in designer.


397. my source is having 1000 rows. i have brought 300 records into my ODS. so next time i want to load the remaining records. so i need to load from 301 th record. when ever i start the work flow again it will load from the begining. how do we solve this problem. thanks in advance kiran

398. what is surrogatekey ? In ur project in which situation u has used ? explain with example ?

399. can we modify the data in flat file?

401. What is Datadriven?