Ho presentato la mia candidatura online. Ho sostenuto un colloquio presso Tata Consultancy Services (Gurgaon, Haryana) nel mese di ago 2023
Colloquio
Basic informatica and SQL queries Lookup transformation.second highest salary,what is the process of performance tuning, How will you maintain scd 1 ,scd2 . What is the difference between incremental load and full load. Difference between lookup and joiner transformation. How many transformation can a source qualifier perform. Do we have to commit after any ddl command. Left outer join .right outer join ,inner join ,full outer join ,cross join
Ho sostenuto un colloquio presso Tata Consultancy Services (Chennai)
Colloquio
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
Domande di colloquio [1]
Domanda 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
Ho presentato la mia candidatura online. La procedura ha richiesto 2 settimane. Ho sostenuto un colloquio presso Tata Consultancy Services (Mumbai) nel mese di set 2024
Colloquio
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
Domande di colloquio [1]
Domanda 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