Data is passed from one active trans and one passive trans
into a passive transformation.Is the mapping valid or
invalid?
Post New Answer View All Answers
How do you load unique records into one target table and duplicate records into a different target table?
How many transformations can be used in mapplets.
What is a pre-defined event and user-defined event?
During the running session, output files are created by informatica server. Enlist few of them.
Explain pushdown optimization and types in informatica
Explain pushdown optimization $pushdownconfig parameter - informatica
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
Clarify the utilization of aggregator cache record?
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.
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
How many number of sessions can one group in batches?
Enlist few areas or real-time situations where informatica is required.
How to extract sap data using informatica? What is abap? What are idocs?
what is size of u r database?