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 pmrep command?
what is the difference steps for data modeling?
what is HISTOGRAM? how to generate statistics?
Define Dynamic push down optmization?
What is a materialized view log?
When you have 2 servers in two different time zone and if you need to extract data from 1 server and load it in another server, how do you go about it? Best method to be used.
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?
Which transformation we use to convert 'NA' to 'Not Available'
Explain do we need an etl tool? When do we go for the tools in the market?
what is the difference between normal & bulk loading? and which one is recommended ? why?
what are the types in error loging?
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?