Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 9 Answers
- 13563 Views
- IBM, I also Faced
- E-Mail Answers
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
How to create the source and target database connections in server manager?
How can a transformation be made reusable?
How does the aggregator transformation handle null values?
What is resilience time?
What are the types of data warehouses?
How to load a Dimension ? and how to load a fact table?
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
What does cheating measurement mean?
What are the new features of informatica 9.x at the developer level?
how to create user defined function (udf) in informatica
What are the advantages of using informatica as an etl tool over teradata?
can any one give some examples for pre sql and post sql(Except dropping and creating index).
In which transformation you cannot drag ports into it?
Different sorts of metadata that stores in the storage facility?
What is a filter transformation?
