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 / abhishek kumar

in aggregator---
record(field) group by
total_record <- count(record)
router---
condition1 <- (total_record)/2
default
send to target
condition1 to target first and
default to target second.

Is This Answer Correct ?    1 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are pre and post-session shell commands?

733


Different circumstance which drives informatica server to expel records?

549


What is lookup transformation?

584


Describe an informatica powercenter?

602


Explain joiner transformation in informatica

662






How to join three sources using joiner? Explain though mapping flow.

688


if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.

1753


Define update strategy?

630


What is rank index in rank transformation?

599


What do you understand by term role-playing dimension?

566


difference between informatica 8.1.1 and 8.6

3236


What are the measure objects?

655


How can you generate reports in informatica?

571


Define the various join types of joiner transformation?

557


In development project what is the process to follow for an etl developer from day1

1271