I have a condition sal=100 and I created one router and in
that two groups g1 and g2 in g1 Sal<=100 and g2 Sal>=100,
first which condition will satisfy, and Why?
Answers were Sorted based on User's Feedback
Answer / jegan
i don't think. If the incoming record satisfies the first
condition, it will go to the first group. One record can't
be transferred to both the groups
| Is This Answer Correct ? | 2 Yes | 11 No |
If we use sorted ports in aggregator transformation and somehow records are not in order by format so what will happen,session fails or it succeeded with incorrect data?
how to get the first row without using rank t/r?
i have a source table ID NAME SAL 101 A 1000 102 B 2000 103 C 1500 target load should be ID NAME SAL 101 A 1000 101 B 2000 101 C 1500 102 A 1000 102 B 2000 102 C 1500 103 A 1000 103 B 2000 103 C 1500
What is union transformation?
Explain pushdown optimization and types in informatica
Can you use the maping parameters or variables created in one maping into any other reusable transformation?
guys which is the best institute in banglore to learn informatica??
What is Cognos script editor?
What are the unsupported repository objects for a mapplet?
I have source like col1,col2,col3,col4 and the values are like 3,6,1,7 1,5,3,8 2,1,5,6 i want the output like 3,6,7 5,3,8 2,5,6 How we will achieve in this scenario in informatica level. Please help me.. Thanks in advance..
HOW TO JOIN THE 2 FLAT FILES WITHOUT USING JOINER AND LOOKUP?
How do you load unique records into one target table and duplicate records into a different target table?