Interested to Buy Any Domain ? << Click Here >> for more details...
If i havee 3records in my source having same deptno like
Deptid Deptno
------ ------
101 10
201 10
301 10
and i am using router TR to loading these records into
target.Then how many record'll be loaded into target???
- 5 Answers
- 11631 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / dave
All 3 records unless DEPTNO is unique constrain and then
you'll get 'Error' and only one records will be loaded
(random record Router is not sorting)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is an active transformation?
How is union transformation utilized?
Explain incremental aggregation in informatica
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
What are the features of complex mapping?
What is informatica worklet?
What are the main issues while working with flat files as source and as targets ?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
Explain the different kinds of facts.
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
How would you copy the content of one repository to another repository?
Which transformation should we use to normalise the COBOL and relational sources?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
what is degenerated dimension?
