how to design mapping half of source table records into one
target and remaining half into another target

Answer Posted / ravi

by using router transformation

Is This Answer Correct ?    2 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between writing a joiner query in ANSI style and THETA style?

1917


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

1733


Describe expression transformation?

636


Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure

6470


Enlist some properties of sessions.

626






what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?

1774


What are junk dimensions?

632


Can one use mapping parameter or variables created in one mapping into any other reusable transformation?

599


Write the unconnected lookup syntax and how to return more than one column.

593


Repository user profiles

1376


How will the document be delivered to me?

617


What is a predefined event?

658


What are connected or unconnected transformations?

628


What is the difference between informatics 7x and 8x and what is latest version?

545


How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?

1618