suppose i have 1000 records and i want to load half of the
record in target 1 and half in target2.how u'll do?

Answer Posted / mike

src-->source qual--->exp--->router--->target

based on the conditions we can use other trn's

correct me if i was wrong

Is This Answer Correct ?    7 Yes 11 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Write the program through which the records can be updated?

725


What is a sorter transformation?

867


What are the differences between source qualifier and joiner transformation?

790


Please let me know how to make encryption and decryption with example?

1668


Clarify the aggregator change?

759


How to create Target definition for flat files?

961


permutations of mapplet

2239


What are the different types of transformation available in informatica.

818


Enlist the tasks for which source qualifier transformation is used.

767


What are the differences between oltp and olap?

716


Explain in detail about scd type 1 through mapping.

812


Explain the different kinds of facts.

728


Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?

826


Explain scd type 3 through mapping.

761


what are the fact table & dimensional table in pharmaceutical and hospotal related products???

1884