Informatica Online Training

Learn MonsterCourses | IT Video Tutorials | Course Material – Performance Tuning in Informatica How do you identify the bottlenecks in Mappings? Bottlenecks can occur in1. Targets the most common performance bottleneck occurs when the informatica server writes to a target database. You can identify target bottleneck by configuring the session to write to a flat file target. If the session perf...

Learn MonsterCourses | IT Video Tutorials | Course Material – INFORMATICA SCENARIOS I have listed the following informatica scenarios which are frequently asked in the informatica interviews. These informatica scenario interview questions helps you a lot in gaining confidence in interviews.

Informatica FAQ, Informatica Material:

60) explain joiner transformation?
Joiner transformation joins two related heterogeneous sources residing in different locations or files.
--What are the types of joins in joiner in the joiner transformation?
Normal
Master outer
Detail outer
Full outer
61) Difference between connected and unconnected transformations.
Connected transformation is connected to another transformation with in a mapping.
Unconnected transformation is not connected to any transformation with in a mapping.

62) In which conditions we cannot use joiner transformation(limitations of joiner transformation)?
Both pipelines begin with the same original data source.
Both input pipelines originate from the same source qualifier transformation.
Both input pipelines originate from the same normalizer transformation
Both input pipelines originate from the same joiner transformation.
Either input pipelines contains an update strategy transformation
Either input pipelines contains sequence generator transformation.
63) what are the settings that u use to configure the joiner transformation?
Master and detail source.
Type of join
Condition of the join
64) what is look up transformation
look up transformation can be used in a table view based on condition by default lookup is left outer join
65) why use the lookup transformation?
To perform the following tasks.
Get a related value.For example if your table includes employee ID,but you want to include such as gross sales per invoice or sales tax but not the calculated value(such as net sales)
Update slowly changing dimension tables. You can use a lookup transformation to determine whether records already exist in the target.
66) what are the types of lookup?
Connected and unconnected
67) difference between connected and unconnected lookup?
Connected lookup Unconnected lookup
Receives input values directly from the pipe line. Receives input values from the result of a clkp expression in a another transformation.
U can use a dynamic or static
Cache U can use a static cache
Cache includes all lokkup columns used in the mapping(that is lookup table columns included in the lookup condition and lookup table columns linked as output ports to other transformations) Cache includes all lookup/output ports in the lookup condition and the lookup/return port.
Can return multiple columns from the same row or insert into the dynamic lookup cache. Designate one return port(R).Returns one column from each row.
If there is no match for the lookup condition, the informatica server returns the default value for all output ports.If u configure dynamic caching the informatica server inserts rows into the cache. If there is no matching for the lookup condition the informatica server returns NULL
Pass multiple output values to another transformatnion.Link lookup/output ports to another transformation Pass one output value to another transformation.The lookup/output/return port passes the same value to the ---------------------------------------------------------
Supports user-defined default values.
Does not support user-defined default values.

68) explain index cache and data cache?
The informatica server stores conditions values in the index cache and output values in the data cache.
69) What are the types of lookup cache?
Persistent cache: U can save the look up cache files and reuse them the next time the informatica server processes a lookup transformation to use the cache.
Static cache: U can configure a static or read-only lookup table.By default informatica server creates a static cache.It caches the lookup table and lookup values in the cache for each row that comes into the transformation.When the lookup condition is true the inforamtica server does not update the cache while it processes the lookup transformation.
Dynamic cache: If you want to cache the target table and insert new rows into cache and the target you can create a look up transformation to use dynamic cache.The informatica server dynamically inserts data into the target table.
Shared cache: You can share the lookup cache between multiple transformations.You can share unnamed cache between transformation in the same mapping.

70) Difference between static cache and dynamic cache?
Static cache Dynamic cache
You cannot insert or update the cache You can insert rows into the cache as you pass rows to the target
The informatica server returns a value from the lookup table or cache when the condition is true,.When the condition is true the informatica server returns the default value for connected transformation The informatica server inserts rows into the cache when the condition is false.This indicates that the row in the cache or target table.You can pass these rows to the target table.
ORACLE:
71) Difference between primary key and unique key?
Primary key is Not null unique
Unique accept the null values.
72) Difference between inserting and sub string?
73) What is referential integrity?
74) Difference between view and materialized view?
75) What is Redolog file?
The set of redo log files for a database is collectively know as the databases redo log.
76) What is RollBack statement?
A database contains one or more rollback segments to temporarily store undo information.Roll back segment are used to generate read consistant data base information during database recovery to rooback uncommitted transactions for users.
-- what is table space?
A data base is divided into logical storage unit called table space.A table space is used to grouped related logical structures together.
-- How to delete the duplicate records.
-- What are the difference types of joins in Oracle?
Self-join,equi-join,outer join.
77) What is outer join?
One of which rows that don’t match those in the commen column of another table.
78) write query Max 5 salaries?
Select * from emp e where 5>(select count(*) from emp where sal>e.sal)
79) what is synonym?

80) --------------------------------
81)
82) What is bit map index and example?
83) What is stored procedure and advantages?
84) Explain cursor and how many types of triggers in oracle?
Trigger is stored procedure.Trigger is automatically executed.
85) Difference between function and stored procedure?
Function returns a value.Procedure does not return a value(but returns a value tru IN OUT parameters!!!!!!)
86) Difference between replace and translate?
87) Write the query nth max sal
Select distinct (a.sal) from emp a where &n=select count(distinct(b.sal) from emp b where a.sal