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
- 18196 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 happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
How do you manage the Parameter files while migrating your data from one environment to another environment?
What the difference is between a database, a data warehouse and a data mart?
While migrating the data from one environment to another environment how would you manage the connections?
How can you validate all mappings in the repository simultaneously?
What is mapping debugger?
What is fact table? Explain the different kinds of facts.
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
What's the layout of parameter file (what does a parameter file contain?)?
How to load data in informatica ?
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
What are the restrictions of union transformation?
Can informatica load heterogeneous targets from heterogeneous sources?
How many ways a relational source definition can be updated and what are they?
can we override a native sql query within informatica? Where do we do it?
