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 / 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 are some examples of informatica etl programs?
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
What are the issues you have faced in your project? How did you overcome those issues?
Which means the first record should come as last record and last record should come as first record and load into the target file?
what is informatica metadata?
What does reusable transformation mean?
What are active transformations.
How can we use mapping variables in informatica? Where do we use them?
How do we call shell scripts from informatica?
What is the use of transformation?
if we have a delimiters at unwanted places in a flat file how can we over come those.
Define mapping and session?
How many ways a relational source definition can be updated and what are they?
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?