Why can't we connect 2 active transformations to an active
transformation ?
Ex:- One aggriagator and one sq trans to an router
transformation
The Designer does not allow you to connect multiple active transformations or an active and a passive transformation to the same downstream transformation or transformation input group because the Integration Service may not be able to concatenate the rows passed by active transformations. For example, one branch in amapping contains an Update Strategy transformation that flags a row for delete. Another branch contains an Update Strategy transformation that flags a row for insert. If you connect these transformations to a single transformation input group, the Integration Service cannot combine the delete and insert operations for the row.
| Is This Answer Correct ? | 3 Yes | 1 No |
What is workflow? What are the components of workflow manager?
What is source qualifier?
COM components can be used in Informatica
how lookup is acting as both active and passive ? how is it possitble?
What is persistent lookup cache?
What are roles and groups and benefits of using them?
write sql query to filter the null value data following table? name age john 30 smith null null 34 sharp 24 i want the output following are name age john 30 sharp 24
I have source like this 1:2;3. so i want to load the target as 123
What is Factless fact table ???
12 Answers Satyam, Tech Mahindra,
Mention few advantages of router transformation over filter transformation.
Hi experts ,I have a Source of 1000 records.I have to load 100 records in first target,101 to 200 records in 2nd target, 201 to 300 records in 3rd target and again 301 to 400 in first target like that as cyclick process. How can i acheive this.
Please let me know how to do estimation before staring development in project. Here estimation in the sense how many associates are required, etc to complete the project.