What are cubes and olap cubes?
Explain what is etl process? How many steps etl contains explain with example?
what is data modeling?
what is the use of server manager?
What is Data Vault???
how do u really know that paging to disk is happening while u are using a lookup transform?
List few etl bugs?
what happens if the info.server doesn't find the session parameter in the parameter file?
Informatica server and client are in different machines. You run the session from the server manager by specifying the source and target databases. It displays error . You are confident that everything is correct. Then why it is displaying the error?
What are the names of the layers in etl?
Difference between flat files and relational sources?
Explain about the data integration suite features?
How can you use an Oracle sequences in Informatica ? You have an Informatica sequence generator transformation also. which one is better to use?
What are snapshots? What are materialized views & where do we use them? What is a materialized view log?
can u anyone plz share some etl testing interview question . and share the sql queries and unix . plz help me to clear in the etl testing interview by sharing ur knowledge