Assume u have a 24CPU machine with 24GB RAM, suggest how u would like to configure Informatica ,like number of concurrent sessions, RAM requirements etc,max partitions that u would permit per mapping.
1639how to join two tables without using joiner transformation .advantages of joiner over lookup and vice versa.
5 14548can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.
1 3451
what are the session parameters? How do u set them?
can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.
how would u estimate the size of Aggregator transform data and index cache?
Difference between flat files and relational sources?
what are the reporting tools and difference between them?
what are Lookup caches options? Including persistent caches.
what are the production issues in datastage?
Is apache nifi an etl tool?
Which transformation we use to convert 'NA' to 'Not Available'
Explain the key challenges that you face while performing etl testing.
how would u estimate the size of Lookup transform data and index cache?
What are the steps involved in etl process?
what is the use of structures?how many nodes can u create in a structure?
hoe to access second value in mapping parameter if it is having more than one value ?????????????
When do we analyze the tables?