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
- 17338 Views
- BirlaSoft, Genpact, L&T, Syntel, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
How can you generate reports in informatica?
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
Explain dynamic target flat file name generation in informatica
How you prepared reports for OLAP?
How might you approve all mappings in the archive all the while?
What is an Integration service in Informatica?
What is workflow? What are the components of workflow manager?
What is a router transformation?
What do you mean by filter transformation?
How to load a Dimension ? and how to load a fact table?
How can we use mapping variables in informatica?
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
What are the prerequisite tasks to achieve the session partition?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
Where do we use mapping variables in informatica?
