how can send duplicate records to one tableand non
duplicate records to one table with simple clear mapping?

Answer Posted / sivananda reddy

In informatica use this mapping

source->sqr->aggr->router->exp->target1
|
|->exp->target2

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

The question was on time stamp. what is the difference between HH and HH24 when to use when.

1542


I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.

1192


What do you mean incremental aggregation?

615


Write the program through which the records can be updated?

501


Which means the first record should come as last record and last record should come as first record and load into the target file?

599






Explain sessions. Explain how batches are used to combine executions?

583


What is meant by lookup transformation? Explain the types of lookup transformation?

555


source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.

2286


i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance

1661


How can we handle two sessions in informatica?

604


What are the issues you have faced in your project? How did you overcome those issues?

1903


What is a repository? And how to add it in an informatica client?

638


explan ur project architecture?

1585


What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?

1621


What do you understand by term role-playing dimension?

560