Difference between synchronisation and replication task in IICS Lookup and why is it used Scd type 2 How to check why session or workflow failed? Types of files created by Informatica session Can we write lkp override for flat file? Sql to remove duplicate records Types of tasks in Informatica Stop and abort difference Types of constraints
Calculate second maximum salary in Oracle
Informatica concepts, Datawarehouse, SQL queries etc..
What is ETL? Complex Mapping? Performance Tuning. Push down optimization query? Sequence Generator?
They asked me about my college project
1. Source directory had N nbr of files. Use informatica and send to target filename and count of data of each file in that folder. 2. Delete dups in a table. SQL 3. Full form of GREP. 4. Flat file having string word in every line. For complete file, send count of each alphabet in target. Implement through Informatica.
Questions asked from various informatica Transformations- Stored procedure, Joiner, XML Phaser, Lookup.
Where to check which instance of a process is running?
What are Potential and Action Table?
Parla della tua carriera universitaria.
Viewing 241 - 250 interview questions