Informatica Interview Questions

Using Sorter Transformation it will delete duplicate records and using Expression Transformation... "c S->SQ->EXP->Router->TR.... Exp Logic=V_Prod_id=Prod_id V_Dup_...

Use sorter transformation after SQ and check the distinct check box of sorter.finally connect to the tgt.

Stored Procedure

Hi,Its usually not done in the mapping(transformation) level. Its done in session level. Create a command task which will execute a shell script (if Unix) or any other scripts which contains the creat...

There is no different between them. The only thing is, SQL override is executed at the beginning of a mapping and the SQL-Transformation is executed downstream of the mapping

Using Router transformation we will achieve this.

S -> SQ -> RTR -> T

In router,create 10 groups for 10 countries

You need to use TC here, the country names may not be known to you at prior.

By default when we create the session, workflow creates pass-through partition points at Source Qualifier transformations and target instances.  Partition points mark the thread boundaries in...

When you create or edit a session, you can change the partitioning information for each pipeline in a mapping. If the mapping contains multiple pipelines, you can specify multiple partitions in some p...

You can use the following logic

FF-> SRT(in descending order)=>EXP=> FLT=>TGT
||
SEQ

filter the seq generated values from 1-100 this will load the last 100 values to the target

Rank solves the problem based on the attribute you are ranking on. if the attribute is not the distinct, then this would not resolve. I also need right answer for this.

You can utilize the MD5 hash functionality within the mapping

I am assuming the source ia a flat file with no header record but footer record for count. You can have a set of unix command in a unix script and execute the script from pre-session command. Check th...

Yes we can update target without using Update Strategy Transformation in
session->mapping->target->treat source rows as
Update
Update as Update
Update else insert
Update as Insert

Yes we can update by setting property at session level called treat source rows as UPDATE.

ECHO OFF This automates the informatica workflow run using pmcmd ECHO c:informaticaserverinpmcmd startworkflow -u username -p password -s server:host -f Folder -wait MYWORKFLOW

C:-->Program Files-->Informatica PowerCenter 7.1.3-->Server-->bin-->pmcmd.exe

For explaining your sales project: You can follow these points and cover them based on your actual project. 1. Name of the Project 2. Name of the Client 3. Brief Description of the Client 4. Brief ...

you need a one source qualifier pipeline to aggregator then ==> a joiner to join aggregator and source qualifier ==> then expression to calculate percentage==> push it to target

Source --> sq --> 2 exps In one expression take a variable port v_port store cum(Contribution) and check the FamilyID to previous ID i_familyID v_family=iff(i_familyID=v_priv_familyID),contribution...

The main logical difference is that we use connected lookup while loading dimensions and unconnected look up while loading facts

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)

Start your project description, then move on to your role and responsibilities and then about your team and so on...

The lookup function is used to compare source data with another table based on a certain condition. If the condition is true than the lookup function returns columns that satisfy condition.
The default transformation for lookup function is lookup transformation.

Set source file type as INDIRECT

Step 1: Transfer all the 5 files on to your UNIX box or server from where you will fetch those 5 files Step 2: open notepad and type the 5 files name .ex:- a.csv ...

Hi..
As uma told...she is rite,but may i know how to create footer in a flatfile

you can always create a header and a trailer in the target file using an aggregator transformation.Take the number of records as count in the aggregator transformation.create three separate files in a...

If we have to do stop it will stop that step only.again we have to start the workflow then that time it will start which step u have to stop that step only it start run the workflow then abort says we...

Stop waits for all running objects to complete and then terminate the process however abort stops the entire object running immediately. Eg: A workflow is in running state and it’s having 5 session...

There are 4 Types of Joiner Trasnformations: 1) Normal 2) Master Outer 3) Detail Outer 4) Full Outer Note: A normal or master outer join performs faster than a full outer or detail o...

follw thisIn the Mapping Designer, choose Transformation-Create. Select the Joiner transformation. Enter a name, click OK. The naming convention for Joiner transformations is JNR_TransformationName. E...

we can use SCD without using lookup.

As of my knowledge we can do SCD Type 2 by using joner transformation. First take the source and target(i.e which is target) as source and join these two by using surrogate key like master outer join(...