Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 8 Answers
- 18519 Views
- L&T, TCS, UnitedHealth Group, Wipro, I also Faced
- E-Mail Answers
Answer Posted / sehaj
CREATE A MAPPING VARIABLE WITH AGGREGATION TYPE AS COUNT.
DEFINE ITS INITIAL VALUE AS 0.
THEN IN EXPRESSION CREATE AN OUTPUT PORT.
COUNT-SETCOUNTVARIABLE(VARIABLE NAME).
USE AN AGGREGATOR TO FIND THE TOTAL NO F RECORDS.
IN ROUTER
CREATE TWO GROUPS
IN FIRST GROUP ENTER CONDITION
COUNT<=(TOTAL NMBR F RECORDS)/2
IN SECOND GROUP ENTER CONDITION
COUNT>(TOTAL NUMBER F RECORDS)/2.
SEHAJ....
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
what is the hint? how to use it to reduce the query processing in program?
How do you load only null records into target?
What are roles and groups and benefits of using them?
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
How do you update the records with or without using update strategy?
What is native users?
How many numbers of sessions can one group in batches?
What does reusable transformation mean?
Performance tuning in UNIX for informatica mappings?
Different sorts of metadata that stores in the storage facility?
How can we remove the duplicates from flat file source?
Explain informatica architecture - version 8 / 9
Enterprise data warehouse your projects phase by phase explain?
What does “tail –f” command do and what is its use as an Informatica admin.
What are the reusable transformations?
