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
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
what is song in infrmatica...?
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 different lookup cache(s)?
What is workflow? What are the components of the workflow manager?
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
is it possible to index the data in cache of lkp transformation ?
Explain the informatica workflow?
What is informatica worklet?
How to do unit testing in informatica? How to load data in informatica ?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
What are the different clients of powercenter?
What are session parameters ? How do you set them?
How to join three sources using joiner?