Informatica power Center or IICS Interview Question and answers Q&A 4.
31.What is project source name
Its Depend on your project. Usually, Client name will be the project name.
Ex:
Wesco DW
ICICI DW
AMFAM DW
32.How to pass values between seesion in a workflow
Create a workflow variable $$wf_var.
On successful completion of mapping 1(session 1) , assign
$$wf_var=$$var1 (post session workflow assignment)
In mapping2(session2), use pre-session workflow assignment, and
assign $$Var2=$$wf_var.
33.Find the 1,2,3 highest salary without using rankfunction ?
Using Sorter transformation descending order and put row id lessthan 4
Select * From Employee E1
Where N = (Select Count(Distinct(E2.Salary)) From Employee E2 Where E2.Salary greater than= E1.Salary)
34.Is it necessary to enable sorter input option in joiner
Informatica PowerCenter expects the Joiner to have sorted input if the
*master-detail inputs are from the same source*, Since the sorted input
is selected, ensure that there are Sorter transformations added for each
Joiner input.
35.What is incremental aggregation
Using incremental aggregation, you can apply changes captured from
the source to aggregate calculations such as Sum, Min, Max, Average etc…
If the source changes incrementally and you can capture changes, you
can configure the session to process those changes.
This allows the Integration Service to update the target
incrementally, rather than forcing it to process the entire source
and recalculate the same data each time you run the session.
36.What is trigger
Triggers in oracle are blocks of PL/SQL code which oracle can execute
automatically based on some action or event to be performed in response
to an insert, update, or delete operation against a table Triggers are
created using the PL/SQL CREATE TRIGGER statement.
37.How to optimize mapping
Generally, we will identify source bottlenecks, Target bottlenecks and
Transformation bottlenecks. Based on these we will optimize Source side
, Target side or Transformation side in a mapping .
38. Types of data you are getting for your project
Usually, we will get Business Transactional data in the form or source
flat files or source tables.
39.How many ways we can override the query
In Informatica PowerCenter, we can override the query as mentioned in
the below.
By using SQL Query option in Source Qualifier Transformation.
By using Lookup SQL Override in Lookup Transformation.
By using Pre-SQL and Post-SQL in Source and target side.
By using SQL Transformation in Informatica.
40.How will do error handling
There Are many ways to do Error handling in Informatica. But in our
project, we have followed the below steps as a part of error handling.
Make Stop on Error as 1 to avoid the in-session properties to
avoid the workflow success when any rejected records.
Use the options “*Fail Parent if the task fails*” and also “*Fail
the parent if this task does not run* “to avoid workflow success
when any session failures.
Use the property Recovery Strategy as *Restart Task*.
41.In informatica. If you have special characters in the column first name how will you remove it ?
REG_REPLACE(FIRST_NAME, ‘[^\w,-. ]’, ”)
Use the above function in expression Transformation, that removes the
special characters and retains only alphanumeric characters, commas,
dashes, and periods.
informatica interview preparation,informatica interview scenarios,informatica interview questions,informatica interview videos,informatica interview,informatica admin interview questions,informatica interview tips,informatica interview questions and answers,informatica powercenter interview questions,technical interview questions,informatica questions,informatica training,informatica answers,informatica powercenter,informatica tutorial
informatica intelligent cloud services, iics informatica tutorial, iics to cloud data base connection, iics data integration tutorial, iics cloud data integration services, iics training informatica, iics tutorial for beginners, iics informatica tutorial telugu, iics informatica, iics informatica interview questions, iics informatica resume, iics informatica training, iics data integration, iics data integration interview questions, what is informatica iics, iics login issue, informatica intelligent cloud services, iics, iics Informatica Cloud secure agent,
informatica or IICS interview question and answers for 2 years experience
informatica or IICS interview question and answers for 3 years experience
informatica or IICS interview question and answers for 4 years experience
informatica or IICS interview question and answers for 5 years experience
informatica or IICS interview question and answers for 6 years experience
Interview Question and answers of Informatica power center or IICS