how to get flatfile containg 10 records half records one
target another half another target
- 2 Answers
- 4792 Views
- I also Faced
- E-Mail Answers
Answer Posted / gazulas
what if the number 10 changes??
use a sql transfermation and get the record count or use an agg get rec count and pass it into record_count. use seq gen and populate the numbers. then use a router and write condition seq no <= record_count/2 -- target1
default to target 2.
this will work even ur records changes to 100 or 25o or 40000..etc
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
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 is the difference between router and filter?
How to create Target definition for flat files?
What are active and passive transformations?
Differentiate between a database and data warehouse?
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.
Explain how many types of dimensions are available in informatica?
Do you find any difficulty while working with flat files as source and target?
Tell me about Propagate functions in informatica
What are the data movement modes in informatica?
What are the new features of informatica 9.x in developer level?
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?
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
permutations of mapplet
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
