What are the three tiers in etl?
how to connect to a flatfile through ftp in informatica
Do we need an etl tool?
how to join two tables without using joiner transformation .advantages of joiner over lookup and vice versa.
diff b/w dwh & data mart diff b/w star schema & snow flake schema diff b/w fact table & dimension table what are the contents in requirement specification what are the docs needed for testing draw ur proj architecture
how do u really know that paging to disk is happening while u are using a lookup transform?
if i have a query as flat file how can we load data to target table
how do u identify the changed records in operational data?
where we cannot use sorter Transformation. if we use then we will not get correct data?
where are the log files generally stored.Can you change the path of the file.what can the path be?
what are the facilities provided by data warehouse to analytical users?
what is the difference steps for data modeling?
How can we handle Rejection Logic in Source tables while we are matching the data in Target side in ETL Testing ?