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
- 10319 Views
- CTS, I also Faced
- E-Mail Answers
Answer Posted / p1khatri
using Dynamic lookup :-
for new record (i.e. Newlookuprow =1)insert into tgt 1
for duplicate records (i.e. Newlookuprow=0) insert into tgt
2
I hope this'll work
| Is This Answer Correct ? | 7 Yes | 6 No |
Post New Answer View All Answers
What is confirmed fact in dataware housing?
What are mapplets?
What is an expression transformation in informatica?
What is expression transformation?
What is meant by active and passive transformation?
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
How to extract sap data using informatica? What is abap? What are idocs?
Can informatica load heterogeneous targets from heterogeneous sources?
What is the need of an ETL tool?
Why is sorter an active transformation?
explain about unit testing? in real time?
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
What is enterprise data warehousing?
Which is the t/r that builts only single cache memory?
How can we store previous session logs?
