i have f;latfile source. i have two targets t1,t2. i want to
load the odd no.of records into t1 and even no.of recordds
into t2.
Answer Posted / akash
By using Router Transformation
SQL Server : (id%2 = 0 or 1)
Oracle : mod(id,2) = 0 or 1
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the use of target designer?
What is the format of informatica objects in a repository?
Differentiate between router and filter transformation?
Make a note of the quantity vaults made in informatica?
In informatics server which files are created during the session rums?
Is it possible to use a client with different version than that of its Informatica server?
How can you differentiate between powercenter and power map?
What is a standalone command task?
what are 3 tech challenges/ common issues you face?
Which version configuration tool used in ur project?
have u done any performance tuning? how u ll do?
Tell me about Propagate functions in informatica
Describe the impact of several join conditions and join order in a joiner transformation?
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N