I have a scenario with router transformation. but i dont want
to capture records from default group. how can we achieve
this.
Answers were Sorted based on User's Feedback
Answer / kishor baindoor
Dont connect any out port of router's default group to next
stage.
| Is This Answer Correct ? | 14 Yes | 1 No |
Answer / ankita jain
Just ignore the data from default group.. means dont connect to it. See below example for more details
http://www.tutorial.tecktricks.com/example-of-router-transformation-in-informatica-example-1/
| Is This Answer Correct ? | 1 Yes | 0 No |
what is the size of u r source(like file or table)?
write a query to follwoing table amount year quarter 254556 2003 first 546332 2003 second 129034 2003 third 490223 2003 fourth 165768 2004 first 265443 2004 second 510412 2004 third 435690 2004 fourth i want the output year q1_amount q2_amount q3_amount q4_amount 2003 254556 546332 129034 490223 2004 165768 265443 510412 435690
What is substr in informatica?
In a sequential batch can you run the session if previous session fails?
Suppose we are using a Dynamic Lookup in a Mapping and the commit Interval set for the tgt is 10000. Then how does the data get committed in the lookup if there were only 100 roows read from the src and the dynamic lookup dint have the 100th row in it?
Can anyone please help me out,In which transformations records will be rejected and how capture those records?and How to reload the rejected records?
what is bridge tables in informatica
How to load last 10 records of flat file in to the target?
how can we check whether a particular cache is static or dynamic?
In Datastage, we have row generator stage to generate dummy row. Is there any such transformation in Informatica. Thanks in advance, Kumar
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?
What are the differences between a connected lookup and unconnected lookup?