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
What is meant by query override?
How to update source definition?
Explain pushdown optimization $pushdownconfig parameter - informatica
How can a transformation be made reusable?
Differentiate between reusable transformation and mapplet.
How to update a particular record in target with out running whole workflow?
How do you load first and last records into target table?
What do think which one is the better joiner or look up?
What is sequence generator transformation in informatica?
How many types of sessions are there in informatica.please explain them?
what is size of u r database?
Explain why we use partitioning the session in informatica?
How to create the source and target database connections in server manager?
differences between service based and product based?
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?