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
- 13350 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
what is the size of your data warehousing?
What are the types of lookup transformation?
how tokens will generate?
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
What is the benefit of session partitioning?
what are the Methods For Creating Reusable Transformations?
have u done any performance tuning? how u ll do?
What are the new features of informatica 9.x at the developer level?
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
What is main use of mapplet?
How will the document be delivered to me?
What is the benefit of partitioning a session?
Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks
tell me 5 session failure in real time how can you solve that in your project?
