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?
1 4680how do u estimate the depth of the session scheduling queue? Where do u set the number of maximum concurrent sessions that Informatica can run at a given time?
2890how do u estimate the number of partitions that a mapping really requires? Is it dependent on the machine configuration?
1 3723
give detail on the sales project how many number of dimensions & fact tables are used in projec briefly. how the four fact tables taken in the project.
how do u extract data from different data sources explain with an example?
What is tracing level? How many types of transformations supported by sorted input?
What is fact? What are the types of facts?
How to delete data which is not in source table?
Informatica server and client are in different machines. You run the session from the server manager by specifying the source and target databases. It displays error . You are confident that everything is correct. Then why it is displaying the error?
What is full load & incremental or refresh load?
can be used COM component in Informatica ?
how to do aggregation (year wise quantity ) using only source qualifier, the source is sql server date as datetime data type and target as flat file with year (string datatype)
what is session partitioning?
What are the etl testing operations includes?
What is tracing level?
How etl testing is different from database testing?
HI, Anybody is having informatica Dumps,if it there Can u send to my mail id :sathesh.cool@gmail.com
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.