Answer Posted / swetha
When yoU add a relational or a flat file source definition
to a maping, yoU need to connect it to a source qualifer
transformation. The source qualifier transformation
represnets the records that the informatica server reads
when it runs a session.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is meant by lookup transformation? Explain the types of lookup transformation?
What is primary and backup node?
What are roles and groups and benefits of using them?
Separate from a database, an information bazaar, and an information stockroom?
How we can create indexes after completing the loan process?
What are the components of workflow manager?
What are the data movement modes in informatica?
can we override a native sql query within informatica? Where do we do it?
What is target designer and target load order?
How do you load alternate records into different tables through mapping flow?
if we have a delimiters at unwanted places in a flat file how can we over come those.
What is a node in Informatica?
How to do unit testing in informatica? How to load data in informatica ?
What is a surrogate key?
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?