suppose i have 1000 records and i want to load half of the
record in target 1 and half in target2.how u'll do?
Answer Posted / koti
add seq generator to target. and make a look up to target..
then SQ--> Expr--> add two ports in expr. and define the
conditions as iif(sno<500,'true','false')-->router transf.
--> target and instance of target.
definetly it can works like SCD!
Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
Please let me know how to make Data masking in informatica..
What are mapplets?
What is decode in static cache?
Can we create a node as a gateway node and the same node can be assigned to a grid?
What is Data Caches size?
explain abt ur project architecture?
How can we use mapping variables in informatica?
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
How to do unit testing in informatica?
What could be the possible resons of locks by user?
what is SDLC way of code development?
What is informatica metadata and where is it stored?
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
Describe the impact of several join conditions and join order in a joiner transformation?
What is informatica powercenter repository?