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
- 13049 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
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
How to Create a folder using pmrep command?
Explain what transformation and how many are there in informatica?
How to configure mapping in informatica?
Explain direct and indirect flat file loading (source file type) - informatica
What are the conditions needed to improve the performance of informatica aggregator transformation?
What is fact table? Explain the different kinds of facts.
explain about unit testing? in real time?
What is lookup change?
What is an aggregator transformation?
Differentiate between joiner and lookup transformation?
What are the tasks that can be performed using sq?
How to update a particular record in target with out running whole workflow?
What is intricate mapping?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
