Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 9 Answers
- 16686 Views
- BirlaSoft, Genpact, L&T, Syntel, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / sujana
record goes 2 both tables..it wil be passed multiple times
| Is This Answer Correct ? | 28 Yes | 1 No |
Answer / prakash kumar kumhar
yes record will store in both target if you r not using any column as a primary key from source column.
if u are using any column from the source as a primary than it will load only in first target i think.
| Is This Answer Correct ? | 4 Yes | 3 No |
Answer / 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 |
Answer / krish
HAY JUST GO THROUGH THE Q IT GIVEN AS ROUTER
SO, IN SECOND CONDITION U WILL FINE SAL=10,000
IF ITS FILTER THEN IN BOUT CONDITION'S
U WILL FINE THE SAL=10,000
THAT IS DIFF BETWEEN
FILTER AND ROUTER
THIS IS THE GOOD SENIOR0 FOR ROUTER AND FILTER DIFF
FOR VERIFICATION USE EMP TABLE
ONCE
| Is This Answer Correct ? | 0 Yes | 3 No |
Explain the mapping variable usage example in informatica
how can u generate sequence of values in which target has more than 2billion of records.(but with sequence generator u can generate upto 2 biliion only)
Can anyone guide me the steps to install informatica PC 8.5.1 with database as oracle
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
ONE FLAT FILE IS THERE WHICH IS COMMA DALAMETED . HOW TO CHANGE THAT COMMA DELEMITER TO ANY OTHER AT THE TIME OF RUNNING ?
What is the internal processes of integration server in Informatica? How data will be extract and load to the target?
What is confirmed dimension and fact?
when will we use unconnected & connected lookup? How it will effect on the performance of mapping?
what is the size ur source like(file system or database)? how many record daily come u r banking project?
0 Answers Cognizant, Flextronics,
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
How to identify bottlenecks in sources,targets,mappings,workflow,system and how to increase the performance?
Data is passed from one active trans and one passive trans into a passive transformation.Is the mapping valid or invalid?
Teradata 
