What are the basic requirements to join two sources in a source qualifier transformation using default join?
1121Post New Informatica Questions
How to update or delete the rows in a target, which do not have key fields?
What is the sql query overwrite in source qualifier in informatica
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
Explain in detail about scd type 1 through mapping.
What is a dimensional model?
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
How to elaborate tracing level?
How are indexes created after completing the load process?
How to do unit testing in informatica?
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
Explain the shared cache and re-cache?
How to use pmcmd utility command?
What is the function of union transformation?
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?
How can we remove the duplicates from flat file source?