Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
Define update strategy?
Where we use dynamic lookup and where we use it?do we generate surrogate keys using dynamic lookup?can we use it for scd type 2 mapping and why?
pmscmd startworkflow -sv <host name> -d <domain name> -u <user name> -p <password> -f <folder name> <workflow name> while running this command I got the error as "no gateway connectivity is provided for your domain name". So anyone please help me how to rectify this error?
Explain about HLD and LLD ?
What is the difference between Active and Passive transformation?
I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?
why cant we put a sequence generator or upd strategy transformation before joiner transformation?
how can run the wf through pmcmd commend? write script?
What are the differences between source qualifier and joiner transformation?
How does a rank transform differ from aggregator transform functions max and min?
What is the difference between the system variables $$$SessStartTime and SESSSTARTTIME?
two tables from two different databases r there . both having same structure but different data . how to compare these two tables ?