Eliminating of duplicate records without using dynamic lookups
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 dynamic insert?
What is Data Vault???
we hava a flat file having more than 1000 records and two targets. i have to write first half of the rows into first targets and next half of rows into second target. how can i do in informetica??
What is a materialized view log?
When do we use dynamic cache and static cache in connected and unconnected lookup transformations? Difference between stop and abort
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?
what are business components in Informatica?
flat filevalidation in informatica
what are the data modeling tools you have used?(polaris)
indatastage 8.1 surrgoate key generates seqences numbers write but there is limite value i want to reset the seqence after gettting some highest value like i want o/p like this 1 2 3 4 5 .............10000 1 2 3.........10000
Explain about round-robi?