Informatica Real time Scenarios.

Scenario 1: How can we load first and last record from a flat file source to target? Solution: Create two pipelines in a mapping 1st pipeline would capture the first record, and 2nd one for last record. 1st Pipeline: src-> sq-> exp(take a variable port with numeric data type and pass through a output port 'O_Test')->filter(pass if only O_Test =1)->tgt 2nd pipeline: src->sq->agg(No group it will pass only last entry)->tgt In session for 2nd instance of target enable 'Append if Exists' option Scenario 2: How to find out nth row in flat file...we used to do top N analysis by using ...

Informatica Interview Questions on Lookup Transformation

1. What is a lookup transformation?A lookup transformation is used to look up data in a flat file, relational table, view, and synonym.2. What are the tasks of a lookup transformation?The lookup transformation is used to perform the following tasks?    Get a related value: Retrieve a value from the lookup table based on a value in the source.    Perform a calculation: Retrieve a value from a lookup table and use it in a calculation.    Update slowly changing dimension tables: Determine whether rows exist in a target.3. How do you configure a lookup transformation?Configure the...

Separate rows on group basis

In Dept table there are four departments (dept no 40,30,20,10). Separate the record to different target department wise. Solution: Step 1: Drag the source to mapping. Step 2: Connect the router transformation to source and in router make 4 groups and give condition like below. router transformation Step 3: Based on the group map it to different target. The final mapping looks like below. router to targe...