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 |
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
Is stop and abort are same in informatica?
without matching columns in two tables. how can you join
LOOKUP Condition is nothing but a Join condition? What type of join condition it,by default ? Using the LookUP Condition How many types of relational conditions we can make ?
What is difference between stored procedure transformation and external procedure transformation?
Define informatica repository?
in my lookup table i want to catch the recently updated records from the source to target,how to achieve this and what is last commit interval point for this?
What are the types of maping in Getting Started Wizard?
When do you use mapping parameters? (In which transformations)
Why we use stored procedure transformation?
What is dimensional table? Explain the different dimensions.
where to store informatica rejected data? How to extract the informatica rejected data?