Informatica Interview Questions

We can solve this issue by the following types: First, we can create a mapping parameter and run the mapping in each time give the parameter value according to your requirement. Second, we can creat...

Put this query in Source Qualifier select empno, ename, sal, deptno from emp_src where deptno not in (select deptno from emp_trg); Then connect it to Rank Transformation In the properties, Select To...

Yes, By using session level properties. In that use follow the steps Session --> Edit --> Properties --> Treat source rows as --> Update and also you should check options in Mapping --> Target --> U...

yes we can , it is the just that update strategy is used for conditional updates, and the update option available at the mapping level in the target is update without any condition.

We can but the results may change what you are expecting in output

what will be if the flag will be Insert and SUM in the agggregator T/R?

From flat file you use the following wys: --> In source analyzer you can create file by manually -->you can import file -->you can use any of the flat file and give session properties in that correc...

Go to Source analyzer , then import XML Source, a wizard opens up.. select the Schema Definition (XSD) of th XML file

When you run the session, give the XML file name and XML file directory path.

It is a automated process of building a data warehouse which involves taking the data from disparate source systems, converting them into a consistent form that can be loaded into the warehouse and pe...

Step 1: Go to session , and in treat source rows as :UPDATE
step2: in target table option select INSERT and UPDATE ELSE INSERT :)
Step 3:Refresh and Run the session .

By using source qualifier transformation to update tha target table,through SQL overriding...

Why Joiner transformation cannot be used when either of the input pipeline contains an Update Strategy transformation.

We cannot use joiner transformation in the following two conditions:-1. When our data comes through Update Strategy transformation, or in other words after Update strategy we cannot add joiner transfo...

service oriented Architecture,Pushdown Optimization,sql t/r is added,java t/r is add

main difference between informatica 7.x and 8.x are:-

1. Java transformation is introduced in Informatica 8.x. while was not in 7.x

2.and Power exchange tool also introduced in informatica 8.x while was not in 7.x

we need to give the option in target level for rejected data (means needs to give the path of the badfiles to capture the rejected data)

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

If the lookup source is same for all the lookups and if we are returning different columns for calculations then it is better to use unconnected lookup with expression instead of using connected lookup.

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

by using BELOW SCENARIO we can do it the flow is like this
SRC-->SQ-->EXP-->T1
T2

Hi Shiva,

You can use Normalizer t/f to achieve the desired output. There is an "Occur" option in Normalizer in which you can mention the no of times you want to load the same source data into target.

Actually Sorter acts as both passive/Active if we check the Distinct Property then it acts as Active othewrwise passive

The Sorter transformation is an Active transformation because its attribute, Distinct provides a facility to remove duplicates from the input rows.

source--->sqt/r--->Target
In session level(advanced file properties) u have to set some of the properties like output type,directory, filename and codepage type.

in repository go to menu tool then queries.query browser dialog box will appear.then click on new button. in query editor,choose folder name and object type after that execute it(by clicking the blue...

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...

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 redo log file in informatica.Its in oracle.

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