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
No Answer is Posted For this Question
Be the First to Post Answer
What are snapshots?
we hava more than 1000 records. i have to select first 5 record, last 5 record and 5 records from middle of the source. how can i do in oracle as well as in informetica??
what is a parameter when and where do u them when does the value will be created. Designing time, run time. If u don't create parameter what will happen?
When you have 2 servers in two different time zone and if you need to extract data from 1 server and load it in another server, how do you go about it? Best method to be used.
Define Dynamic push down optmization?
what are the data modeling tools you have used?(polaris)
What is tracing level? How many types of transformations supported by sorted input?
Hi, I completed MCA in 2006.After studied Informatica,SQL server and basics of reporting tool in one of the training center in chennai.I got subject knowledge only.But I didn't go any job because I scared to face real time.Anyone please advice how can I enter again into this and anyone provide real time exposure with project.
can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.
what are the data modeling tools you have used?(polaris)
how does the server recongnise the source and target databases.Elaborate on this
what is the advantage of persistent cache? when it should be used?