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 is a transaction control transformation?
What are the different clients of powercenter?
Differentiate between Load Manager and DTM?
Explain the scenario which compels informatica server to reject files?
Mention some types of transformation?
what is the hint? how to use it to reduce the query processing in program?
What is the difference between source qualifier transformations source filter to filter transformation?
How to start a workflow using pmcmd command?
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
Scheduling properties,whats the default (sequential)
where to store informatica rejected data? How to extract the informatica rejected data?
What is joiner transformation?
What is expression transformation?
What is a passive transformation?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.