Data is passed from one active trans and one passive trans
into a passive transformation.Is the mapping valid or
invalid?
Answer Posted / chandru
if the date is passed from one active an one passive cannot be connected to the passive transformation the mapping is not valid
but there is a possible way if we have expression(passive) an aggreatror(active) we can connect these active an passive transformation through joiner (active) transformation it is possible
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
How does a rank transform differ from aggregator transform functions max and min?
how tokens will generate?
How does the aggregator transformation handle null values?
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
How many numbers of sessions can one group in batches?
Enlist the advantages of informatica.
What do mean by local and global repository?
In informatica workflow manager, how many repositories can be created?
Separate from an archive server and a powerhouse?
What the difference is between a database, a data warehouse and a data mart?
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
Write the prerequisite tasks to achieve the session partition?
What is meant by query override?
what is the size ur source like(file system or database)? how many record daily come u r banking project?
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.