I have in my source Records like 100,101,102 etc. I have
router transformation which has groups like one group is
empno=100, second group is empno>99. Now i want to know my
source record 100 loads into which group?
Answer Posted / rampriya
if your input satisfies the condition of all your input
groups, then it will go into all of your groups excluding
default group. thats the only reason why router
transformation is active transformation
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
What is standalone command task?
How can we create index after completion of load process?
Can we override a native sql query within informatica?
What is flashback table ? Advance thanks
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
What are the types of caches in lookup? Explain them.
Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM
Explain sessions. Explain how batches are used to combine executions?
What is a filter transformation and why it is an active one?
Explain pmcmd command usage in informatica
How big was your fact table
difference between informatica 8.1.1 and 8.6
Why update strategy and union transformations are active? Explain with examples.
What are the main issues while working with flat files as source and as targets ?
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?