Informatica Interview Questions

If you want to check the records,you can directly use MINUS query for eg

Code
 SELECT  count(*) FROM source
minus
SELECT count(*) FROM target
 
 

1) Check Session Logs
2) Use Preview Data option for Target in PowerCenter once session is completed
3) Sql queries if it is a Relational database

TO_CHAR(DATE,MM) or
TO_CHAR(DATE,MON) or
TO_CHAR(DATE,FMMONTH)

ex :to_char(trunc(sysdate),mm)
to_char(date,mm)

So we create 2 variable for every field on which we have to do error logging. 1 variable will check the condition for error (i.e. check for isnull or check for datatype) and assign NULL if it does not...

It is one of the most common concept which is being implement in alomost all DW projects. A very simple way of handing error and with their approprite messages is:Concat all the columns with a delimet...

Use the file as source, then a sorter, and then a expression to store the previous value,filter those which matches the previous record and the load them into the same flat file as target

By using the sorter transformation, one can delete the duplicate values in a flat file

Make two flows in the same mapping:
flow 1: load both the targets
flow 2: use both the targets as the source and use SQL override to join the tables. Then load them into a single table

I think your question is how to merge the records from two targets after they got loaded? If this is your question then first import the two target tables as source tables. Complete the mapping to loa...

Login to the admin console and delete the repository content and recreate it. Restart the integration service. It works!

There is no predefined structure for bad files. It has the same structure as of the target table.

There is no redo log file in informatica.Its in oracle.

Redo log file stores the value only after the" Commit "Transaction Occurs

1) Create Indexes on look up tables.
2) Try to use static cache instead of Dynamic cache.
3) Use Pushdown Optimization.

there r many ways to improve the mapping which has multiple lookups.1) we can create an index for the lookup table if we have permissions(staging area).2) divide the lookup mapping into two  (a) ...

Delete it

Try these and see if it helps

- Delete statics and try to retrieve.
- Try to export with INDEXES=n STATISTICS=none
- Disable auditing with "noaudit session"
SQL> noaudit session;

• Create mapping variable, say $$Runcount • Use sequence genereator to create unique values for the records, use reset property in the sequence generator • Use expression transformation o Crea...

First create a sequence generator where startwith=1 and maxvalue=3, enable the option "cycle". Make sure cache value is set to 0. In the data flow use expression to collect dataflow ports and add a n...

SCD Type 3 is used when it is necessary for datawarehouse to keep track of historical changes and when such changes will only for finite number of times.

scd type3 is used for loading the current & most previous data into target

We can validate all the mappings in the repository at once. This is possible through the repository manager.

Guru, It is not possible to validate all the mapping to which is present in Repo either from Repo Manager or Designer. The reason , There could be more than one folder, Each folder may contain some...

A Dimension table contain descriptive (detailed) data and a fact table contain measurements (facts) which are used to evaluate a business, all numeric are not a facts but the numeric which are key performance indicators is known as facts.. fact table contain summarized data....

ASHU (KARIMNAGAR)

Please specify the definition sir

Code
printf("hid");

In Informatica 4 types of dimensions are available, these are 1) Degenerate dimensions 2) Junk dimesnsions ( a dimension which contains the less numbers of cordinality vales are less number of ind...

Hi Guys, Please don't answer wrong answers the above mentioned are Schema. , the dimension are discussed bellow. 1.Junk Dimension:Contains miscellaneous data such as flags and indicator 2.Degener...

Index cache : Integration service stores all conditional values in to the index cache and all output values into the data cache.

Please correct me anything wrong

If we talk with respect to Aggregate Transformation , then Index Cache stores the Group Values and data Cache stores the Actual Data which is Row data.

In Stored Procedure transformation we can also specify when the SP should run.Its Normal,Pre-load of the Source,Post-load of the Source,Pre-load of the Target and Post-load of the Target. Pre-load of...

If you are asking this in terms of Stored Procedure Transformation, then the SP would be run before the Source fetches any data (in case you select Source PreLoad) .. and in case of Source PostLoad th...