Interested to Buy Any Domain ? << Click Here >> for more details...
How to extract original records at one target & Duplicate
records at one target? {with out using EXPRESION
transformation and sequence generator transformation?}<-this
is important
- 4 Answers
- 10673 Views
- CTS, I also Faced
- E-Mail Answers
Answer Posted / sankar
by using router transformation
| Is This Answer Correct ? | 4 Yes | 11 No |
Post New Answer View All Answers
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
can we override a native sql query within informatica? Where do we do it? How do we do it?
What is flashback table ? Advance thanks
server hot-ws270 is connect to Repository B. What does it mean?
What is the difference between stop and abort in informatica
expain about the tune parameters?
Can informatica load heterogeneous targets from heterogeneous sources?
What is deployment group?
How many input parameters can exist in an unconnected lookup?
Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks
What will be the approach?
How to load data in informatica ?
How to use procedural logic inside infromatica?
What is data movement mode in Informatica and difference between them?
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
