vedaetl24@gmail.com
+91 9866978830
Menu
Home
About Us
Courses
SQL
Informatica Powercenter
IICS
Snowflake
Interview Questions
Informatica
PowerCenter
Scenarios
SQL
IICS
Contact Us
PowerCenter
Home
Interview Questions
PowerCenter
Interview Questions
Suppose if source has junk files how would you remove it , will you remove it before importing to power center or after importing power center ?
in Scd type 2 scenario we have some records in target If I have to insert first instead of updating (after first time )What would happen ?
In case of job failure in production whom will you report ?
Are you comfortable if you been placed to big data management projects ?
In scf type to we don’t have end date then how we develop scd type 2 ?
What output files does informatica create during running session ?
Can we store pervious session logs ? If yes How ?
Used update strategy in mapping but records are only getting inserted not updated why ?
Actually how you exactly fit into this project ?
Few complex queries how you check it ?
HLD and LLD documents
Md5 function
If there is requirement to support over weekend where there is a critical due to time lines will yoi be able to support and manage ?
Etl process to downstream ?
Project - what is customer perspective in detail ?
How do you raise ticket ?
Dataware concepts ?
Sales table and metadata table - update the source as sales table and how to check the metadata value un target ?
Explain end to end project life cycle from dev to production ?
What all other tools use in your project If there are errors in UAT phase how will you resolve it how you are maintaining versions ?
How will you get updates in your projects from your client ?
What is project source name ?
How to pass values between session in a workflow ?
Find the 1,2,3 highest salary without using rank function ?
Is it necessary to enable sorter input option in joiner ?
What is incremental aggregation ?
What is trigger ?
How to optimize mapping ?
Types of data you are getting for your project ?
How many ways we can override the query ?
How will do error handling ?
In informatica. If you jave spicial characters in the column first name how will you remove it ?
How to remove duplicates in unix ?
Query to split full name into first name, middle name, last name (3columns)
If source has 1000 records. Which partition is used to load 100 records to 10 targets ?
How to pass one session parameter to another session ? Persistent cache
What are different type os parallel processing ?
How will concatenate using unix >
workflow rejected 50 records in the production what is your next step ?
Target override
Which is better operator like or exists ?
Can you plese tell me some acheivements dine by you in your project ?
Can you tell your project architecture ?
How does informatica tool works ?
What is the flow of development in your project ?
What is the difference between function and procedures ?
How you troubleshooting when workflow is failed ?
Difference between session log and workflow log ?
Do you know about migration ?
Source bottle nect how to refuse it ?
How to find second row in a file ?
How we will get to know whether previous command executed in a script is successful or not ?
How you worked in sprint basis or what is the sprint time ?
Scroll