451. How to export mappings to the production environment?

452. can any one tell me how to run scd1 bec it create two target tables in mapping window and there are only one table in warehouse designer(means target).. so if we create one new table in target it gives error..thanks in advance

453. In my source table 1000 rec's r there.I want to load 501 rec to 1000 rec into my Target table ?how can u do this ?


454. What are the properties should be notified when we connect the flat file source definition torelational database target definition?


455. I have a situation here to load the Table into informatica.I have 5 temporary tables as sources. They look like:Table1: (K - Key, N-Null, X,Y,Z - values)K1 X N N N NK2 X N N N N--------------------------Table2: K1 N X N N NK2 N X N N N--------------------------the other 3 tables are in the same way. But there can be a situation like any of the table can contain duplicates like:K1 X N N N NK1 Y N N N N--------

456. what are the different types of transformation available in informatica. and what are the mostly us
what are the different types of transformation available in informatica. and what are the mostly used ones among them

457. Can u generate reports in Informatcia?

458. what does the expression n filter transformations do in Informatica Slowly growing target wizard?


459. How to view and Generate Metadata Reports(for a particular session would like to generate a report which shows source table , source column and related target table , target column) in informatica?

460. What is the diff b/w Stored Proc (DB level) & Stored proc trans (INFORMATICA level) ?again why should we use SP trans ?

461. Which tool U use to create and manage sessions and batches and to monitor and stop the informatica server? Informatica server manager.



462. What is meant by EDW?

463. what are the measure objects


464. what are the real time problems generally come up while doing/running mapping/any transformation?can any body explain with example.

465. how to load the data from people soft hrm to people soft erm using informatica?


466. can batches be copied/stopped from server manager?
467. Can Informatica load heterogeneous targets from heterogeneous sources?


468. What is exact use of 'Online' and 'Offline' server connect Options while defining Work flow in Work flow monitor? . The system hangs when 'Online' server connect option. The Informatica is installed on a Personal laptop.

469. while running multiple session in parallel which loads data in the same table, throughput of each session becomes very less and almost same for each session. How can we improve the performance (throughput) in such cases?

470. what are the enhancements made to Informatica 7.1.1 version when compared to 6.2.2 version? 471. explain use of update strategy transformation

472. what is polling?


473. what is the difference between stop and abort


474. How can you delete duplicate rows with out using Dynamic Lookup? Tell me any other ways using lookup delete the duplicate rows?

475. Could anyone please tell me what are the steps required for type2 dimension/version data mapping. how can we implement it

476. what is the mapping for unit testing in Informatica, are there any other testings in Informatica, and how we will do them as a etl developer. how do the testing people will do testing are there any specific tools for testing

477. Explain the informatica Architecture in detail


478. what happens if you try to create a shortcut to a non-shared folder?

479. In a joiner trasformation, you should specify the source with fewer rows as the master source. Why?

480. What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in INFORMATICA.
481. what are mapping parameters and varibles in which situation we can use it


482. Talk about the Kimball vs. Inmon approaches.Talk about the concepts of ODS and information factory.Talk about challenges of real-time load processing vs. batch.

483. Waht are main advantages and purpose of using Normalizer Transformation in Informatica?

484. Can any one explain real time complain mappings or complex transformations in Informatica.Specially in Sales Domain.


485. Difference between Rank and Dense Rank?


486. hi everyone,can anyone explain error handling in informatica with examples so that it will be easy to explain the same in the interview.

487. how do you create a mapping using multiple lookup transformation?

488. what is mystery dimention?

489. What is the default source option for update stratgey transformation?
Data driven.

490. At the max how many tranformations can be us in a mapping?

491. What is the difference between Narmal load and Bulk load?


492. Can i use a session Bulk loading option that time can i make a recovery to the session?

493. How do you configure mapping in informatica

494. I have an requirement where in the columns names in a table (Table A) should appear in rows of target table (Table B) i.e. converting columns to rows. Is it possible through Informatica? If so, how?

495. what is meant by complex mapping,

496. What is Micro Strategy? Why is it used for? Can any one explain in detail about it?

497. what is a junk dimension

498. What is data merging, data cleansing, sampling?

499. what is difference b/w Informatica 7.1 and Abinitio

500. Can i start and stop single session in concurent bstch?