how to get flatfile containg 10 records half records one
target another half another target

Answer Posted / mahipal reddy

first create a sequence to those 10 records n using filter
or router transformation filter first 5 columns n load into
target similarly remianing 5 records.

Is This Answer Correct ?    5 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Define update strategy?

641


What will be the approach?

584


How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.

642


How do you use reject loader.

2074


In what scenario we use to improve session performance by pushdown optimization?can any one give example?

5268






How does a rank transform differ from aggregator transform functions max and min?

677


Can you generate sequence numbers without using the sequence generator transformation?

604


What are the different versions of informatica?

685


pmscmd startworkflow -sv -d -u -p -f while running this command I got the error as "no gateway connectivity is provided for your domain name". So anyone please help me how to rectify this error?

1055


What is different between the data warehouse and data mart?

630


can u any challenge your project?

1612


How to improve the performance of a session using sorter transformation?

694


Enlist the differences between database and data warehouse.

556


How can informatica be used for an organization?

653


Explain sessions and how many types of sessions are there?

586