how to design mapping half of source table records into one
target and remaining half into another target
Answer Posted / sbvp
hi raj
when we use source as a flat file
if a flat file contians 10 records assume ok
take seq gen t/r- next val
to exp t/r
in that add a new port and give seq gen-nextval to that new
port(suppose call as seq_num ok)
take RTR t/r
create two out ports ok
seq_num<=5
seq_num>=5
contect to two tgrts ok
thanks
sbvp
Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
What is the difference between router and filter?
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
Explain scd type 3 through mapping.
What is data transformation manager process?
What is transformation?
expain about the tune parameters?
What are the steps involved in the migration from older version to newer version of Informatica Server?
What is the meaning of decode in informatica?
What is a sequence generator transformation?
What is confirmed fact in dataware housing?
Did u used latest transformations of 8.6.0? for what?
What is update strategy transform?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
Dimension Object created in Oracle can be imported in Designer Cubes contain measures