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
- 11893 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 update a particular record in target with out running whole workflow?
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
How an expression transformation differs from aggregator transformation?
how many types of dimensions are available in informatica?
To import the flat file definition into the designer where should the flat file be placed?
What is sq transformation?
Explain the code page compatibility?
What do mean by local and global repository?
what are the Methods For Creating Reusable Transformations?
What is pmcmd command?
How can one identify whether mapping is correct or not without connecting session?
What is a joiner transformation and why it is an active one?
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
What is Session and Batches?
