vedaetl24@gmail.com
+91 9866978830
Menu
Home
About Us
Courses
SQL
Informatica Powercenter
IICS
Snowflake
Interview Questions
Informatica
PowerCenter
Scenarios
SQL
IICS
Contact Us
Scenarios
Home
Interview Questions
Scenarios
Interview Questions
One – to – One Mapping
Customizing the Source Qualifier
Concatenating First_Name, Last_Name and other Row Level Functions
Implementing if – else statement using Expression Transformation
How to filter the data using Filter Transformation ?
Multiple Filter Conditions using Filter Transformation
Need of Router of Transformation
Joiner Transformation
Transposing Columns into Rows using Normalizer Transformation
Transposing rows into columns using variable port and aggregator transformation
Combining Multiple Pipelines – using Union Transformation
Usage of Lookup Transformation
Unconnected Lookup Transformation
Update Else Insert at Session Level
Department wise MaxSalary – using Aggregator Transformation
Update Strategy Transformation
Update Else Insert at Mapping level SCD Type – 1
Sorter Transformation
Fixed Width and Delimeter Flat File
Populating Surrogate Key – using Sequence Generator
Source First Record into First Target and Second Record into Second Target
Multiple Flat Files into the target – Indirect File Type
Populating Source FlatFile Name in the target table
Effective Date – SCD– Type-2
Preventing source duplicate records using Lookup Transformation
Cumulative Salary
Variables – Incremental Logic (CDC)
Control Table Logic
Committing at Mapping Level
Dynamic File Generation
Generating sequence numbers without using Sequence Generator Transformation
Assignment Task
Event Wait – File Watch Mechanism
Worklet
Command Task
Email Task
Stored Procedure
Differences between Informatica 7/8 and 9 versions
Incremental Logic Using Parameter File
Complex Mapping
Assigning a value to workflow level variable – using Assignment task
Error Data Handling
Loading Unique Records into one table and duplicate records into another
How to eliminate or avoid duplicate record from flat file to relational table
Generating multiple records in target, based on source column
updating the target table, if target doesn’t have Primary key
How to Load half records into one Target another half records into one target
Performance tuning in Informatica
Ways of creating Parameter file (Types of parameter files
Development Code Standards
How to skip header and footer records while processing Source Files
Handling Surrogate Key, if same target table populated by two mappings and corresponding sessions execute parallelly
Functioning the loops in Informatica while processing from source to target
Skipping or processing last nth records from Source Flat File
Unit Test Plan
Difference between Source Qualifier, Joiner and Lookup transformation
Difference between Dynamic Lookup Cache and Static Lookup Cache
Difference between Connected Lookup and Unconnected Lookup
Development Lifecycle
Differences between Waterfall and Agile Methodology
How to process multiple files without using indirect method
Transposing rows into columns using variable port and aggregator Transformation
How to achieve lag functionality
How to get greater than average salary records dept wise
Pushdown Optimization
Implementing mapping to convert columns into rows
Md5 functionality
How to Load NON-Duplicates into one table and Duplicate into one table ?
How to achieve Rank Functionality in Informatica without Rank Transformation If source is a flat file, How to generate sequence ranks?
How to Compare starting point and destination location of travel to diplay From Destination to Starting point?
Roles and Responsibilities
Scroll