Interested to Buy Any Domain ? << Click Here >> for more details...
HOW CAN I SEND HALF OF THE RECORDS TO ONE TARGET AND
REMAINING TO OTHER TARGET?
- 6 Answers
- 11699 Views
- I also Faced
- E-Mail Answers
Answer Posted / satish potdar
Use a seq generator to tag row number to each row(use reset
option so that it will be reset to 1 after the session is
complete). OR use rownum in Source qualifier query.
Once the rows are tagged,pass constant 1 to aggregator to
get the count, join the aggregator output with source
pipeline USING JOINER(since you cannot join heterogeneous
rows using any other transformation). Use router to route
the rows to different targets using appropriate group
expression.
| Is This Answer Correct ? | 2 Yes | 3 No |
Post New Answer View All Answers
What is a sequence generator transformation?
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
what is INFORMATICA TESTING process
What are the different options available for update strategy?
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks
What could be the possible resons of locks by user?
Explain the scenario which compels informatica server to reject files?
What is confirmed fact in dataware housing?
can we override a native sql query within informatica? How do we do it?
What are the modules in Power Center
What are the basic requirements to join two sources in a source qualifier transformation using default join?
Briefly explain the aggregator transformation?
Explain the different kinds of facts.
