i have flat file it contains 'n' number of records, i need
to send half of the records to one target table and
Remaining half to another target table: pls full details

Answer Posted / sathish

yes aboue mentioned answer is write answer, because aggegater gives total number of records then it passes to router based on that value we cal write a condition in router

Is This Answer Correct ?    1 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a repository manager?

650


what is the end to end process meaning in my project(my project is development)and functionality plz tell me

1505


5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C

1412


What is an unconnected transformation?

667


What is the procedure for creating independent data marts from informatica 7.1?

570






COM components can be used in Informatica

1880


Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.

1844


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

1918


Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance

1599


What is workflow? What are the components of the workflow manager?

646


Tell me about MD5 functions in informatica

530


Explain the types of transformations?

600


suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do

1735


What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?

6422


What is expression transformation?

637