Interested to Buy Any Domain ? << Click Here >> for more details...
suppose if we have dublicate records in a table temp n now
i want to pass unique values to t1 n dublicat values to t2
in single mapping?how
- 4 Answers
- 11044 Views
- CTS, I also Faced
- E-Mail Answers
Answer Posted / laksh
You can do this in one mapping by using sorter and then
expression transofrmation ..in Expression use 3 variables ..
1 Current 2 previous 3 route..
if prevous = current sent to table 2 else 1.
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
how to load rows into fact table in data warehouse
What is a surrogate key?
what is the size ur source like(file system or database)? how many record daily come u r banking project?
What is meant by lookup transformation?
What is parallel processing in informatica?
Explain sql transformation in script mode examples in informatica
Which are the different editions of informatica powercenter that are available?
Why do we need informatica?
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
What is the Rank index port in Rank transformation?
Explain scd type 3 through mapping.
What is decode in static cache?
Why do you use Mapping Parameter and mapping variable?
What is meant by pre and post session shell command?
