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 / babu

Frnds small change in the above answer..

i.e: GRP1 :O_SEQ1>=O_SEQ2 ,GRP2: O_SEQ1<O_SEQ2
OR
GRP1 :O_SEQ1>O_SEQ2 ,GRP2: O_SEQ1<=O_SEQ2

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is it possible to revert a global repository to local one and why?

615


Tell me about Propagate functions in informatica

528


What are the settings that you use to configure the joiner transformation?

617


How do you set a varible in incremental aggregation

1452


Why update strategy and union transformations are active? Explain with examples.

716






How do you use reject loader.

2074


What are the different components of powercenter?

587


What are the types of data warehouses?

949


Explain what are the different types of transformation available in informatica.

576


Explain informatica architecture - version 8 / 9

675


Define enterprise data warehousing?

637


can anyone explain me about retail domain project in informatica?

7442


how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?

5837


without table how to come first record only in oracle?

1861


What do you mean by DTM and Load manager and what is difference between load manager and load balancer?

640