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
- 11888 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / sarat
Method Automated : Use an Unconnected lookup to count the SRC no. of records, and use it in the RTR.
Method Manual : Check COUNT(*) manually and use it in RTR( Not appreciate)
If Agg is used, one record gets loaded in one table only
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
permutations of mapplet
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
How can we delete duplicate rows from flat files?
Quickly characterize reusable change?
What is workflow manager?
What is meant by lookup transformation? Explain the types of lookup transformation?
design of staging area?
How to differentiate between the active and passive transformations?
In informatics server which files are created during the session rums?
What are the steps involved in the migration from older version to newer version of Informatica Server?
What are the different types of repositories created using informatica?
Explain lookup transformation in informatica
Can we get 1st record through Informatica(without sequence number).
