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
What does “tail –f” command do and what is its use as an Informatica admin.
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
What is the way to execute pl/sql script using informatica mapping?
What is a joiner transformation and why it is an active one?
What is the difference between writing a joiner query in ANSI style and THETA style?
How can you validate all mappings in the repository simultaneously?
In warehouses how many schemas are there?
How to generate sequence numbers using expression transformation?
What are session parameters ? How do you set them?
How can we remove the duplicates from flat file source?
What are the main issues while working with flat files as source and as targets ?
What is an unconnected transformation?
what is the size of your data warehousing?
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
How can you increase the performance in joiner transformation?