I applied online. I interviewed at Tata Consultancy Services in Jan 2017
Interview
Informatica power center
...and asked scenario. Olap and oltp.. What are the differences between connected lookup and unconnected lookup?
Connected vs Unconnected Lookups
Connected Lookup Unconnected Lookup
1. It receives input from the pipeline & participates in the data flow. 1. It receives input from the result of an LKP.
2. It can use both, dynamic and static cache. 2. It can’t be dynamic.
3. It can return more than one column value i.e. output port. 3. It can return only one column value.
4. It caches all lookup columns. 4. It caches only the lookup output ports in the return port & lookup conditions.
5. It supports user-defined default values. 5. It doesn’t support user-defined default values.
I interviewed at Tata Consultancy Services (Chennai)
Interview
They asked about your ETL tool, SQL, Linux.
1. What is target load order?
2. Write the difference between connected lookup and unconnected lookup.
3. How you identify duplicates and how to find latest duplicate
Interview questions [1]
Question 1
They asked about your ETL tool, SQL, Linux.
1. What is target load order?
2. Write the difference between connected lookup and unconnected lookup.
3. How you identify duplicates and how to find latest duplicate
I applied online. The process took 2 weeks. I interviewed at Tata Consultancy Services (Mumbai) in Sept 2024
Interview
1st Round was telephonic--> Asked basic about router ,lookup and joiner transformation,Lookup Caches,Difference between unconnected Lookup and connected Lookup.
2nd Round Virtual Technical Interview: How would get specific number record to target like 1st and 3rd.
SCD Types
Schema Change Handling
Aggregation
Working on performance tuning in Informatica Powercenter
Interview questions [1]
Question 1
How would get specific number record to target like 1st and 3rd.
SCD Types
Schema Change Handling
Aggregation
Working on performance tuning in Informatica Powercenter