Answer Posted / sankar
a mapping parameter represent a constent value that can be
define before mapping run.a mapping parameter define a
parameter file which is saved with an extension.prm
a mapping parameter reuse teh various constant value.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
Define the various join types of joiner transformation?
Differentiate between source qualifier and filter transformation?
How to differentiate between the active and passive transformations?
What if the source is a flat-file?
How to handle decimal places while importing a flatfile into informatica?
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
Explain what are the different types of transformation available in informatica.
What is joiner change?
What are some examples of informatica etl programs?
What is a predefined event?
While importing the relational source definition from the database, what are the metadata of source that will be imported?
where to store informatica rejected data? How to extract the informatica rejected data?
What is a router transformation?
without table how to come first record only in oracle?