if i have a file having record sal=10000,and when use router
with two groups having condition sal>5000 in one
group,sal>7000 in other group.and if two groups connected to
two targets.in which target sal=10000 will go?
Answer Posted / chegu
Both records satisfying the conditions go to target
like the emp table has 14 rows,in router we pass the emp data and create 2 groups as sal_1=sal>1100 and sal_2=sal>1500 and then connect to two target tables run workflow,we get 18 records as output satisfying first and second conditions.
Thank you
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks
Name the different lookup cache(s)?
Define mapplet?
What are the conditions needed to improve the performance of informatica aggregator transformation?
What are the types of data warehouses?
Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com
What are session parameters ? How do you set them?
Design time, run time. If you don't create parameter what will happen
Briefly explain the aggregator transformation?
How can we use batches?
can we override a native sql query within informatica? Where do we do it?
In how many ways we can create ports?
How do we call shell scripts from informatica?
What is a connected transformation?
How to load a Dimension ? and how to load a fact table?