If I have router with 10 records, if the condition doesn’t
satisfy the records will pass to the default group,then
where can we see that records and where that records will store?
Answers were Sorted based on User's Feedback
Answer / sravan
If you want to see those records, u have to connect default
group to some other target table. I think, this is the
only way, we can see those records.
| Is This Answer Correct ? | 12 Yes | 0 No |
Answer / gsr
All the rows which do not meet any of the conditions are
passed to the default group. If we dont need the rows in
the default group we can drop them by not connecting them
to another transformation or a target in the mapping. If we
need them we can connect them to another transformation or
a target in the mapping.
| Is This Answer Correct ? | 1 Yes | 1 No |
what is the difference between stop and abort?
What are the limitations of joiner transformation?
Why we need XMLs?
I am Unable to load the FixedWith FlatFile Into The Target.What Is The Reason. PLZ Help Me..
what is the difference between lookupoveride and joiner?
What is limitations of truncate and load option
on a day i load 10 rows in my target and on nextday i get 10 more rows add to my target but out of 5 are update row how ican send them to target?how i can insert and update the records
What are the components of the workflow manager?
when we dont use aggregator in mapping ?
In Datastage, we have row generator stage to generate dummy row. Is there any such transformation in Informatica. Thanks in advance, Kumar
suppose i have 1000 records and i want to load half of the record in target 1 and half in target2.how u'll do?
write sql query following table amount year quarter 1000 2003 first 2000 2003 second 3000 2003 third 4000 2003 fourth 5000 2004 first 6000 2004 second 7000 2004 third 8000 2004 fourth i want the output year q1_amount q2_amount q3_amount q4_amount 2003 1000 2000 3000 4000 2004 5000 6000 7000 8000 can anybady help me to achieve the aboue result by using informatica. thanks in advance.