Two default user groups created in the repository
are____and_____.
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.
What is partitioning? Explain different types of partitioning?
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?
Give a way in which u can implement a real time scenario where data in a table is changing and u need to look up data from it.How will u configure the look up transform for this purpose?
Which transformation we use to convert 'NA' to 'Not Available'
Difference between flat files and relational sources?
what types of repositories we can create in informatica? in real time in which type of repository we will work on?
What is the difference between Data Warehousing and Data Mining?
architural difference between 7.1 workflow monitor and 8.1 workflow monitor.
what is the indicator file and where it is used?
what are the session parameters? How do u set them?