Candidatei-me online. Fui entrevistado pela Tata Consultancy Services (Gurgaon, Haryana) em ago. de 2023
Entrevista
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
Fiz uma entrevista na empresa Tata Consultancy Services (Chennai).
Entrevista
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
Perguntas de entrevista [1]
Pergunta 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
Candidatei-me online. O processo levou 2 semanas. Fui entrevistado pela Tata Consultancy Services (Bombaim) em set. de 2024
Entrevista
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
Perguntas de entrevista [1]
Pergunta 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
