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
- 10721 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / sanjay
By using the Router transformation we can load half of the
record in target 1 and half in target2.
src-->source qual--->Seq Generator(If
needed)--->router--->targets
| Is This Answer Correct ? | 1 Yes | 3 No |
Post New Answer View All Answers
What you know about transaction control transformation?
Is there any target staging area in informatica not staging area
Explain the use of aggregator cache file?
write a query to retrieve the latest records from the table sorted by version(scd)
What is the benefit of partitioning a session?
What is fact table? Explain the different kinds of facts.
Explain joiner transformation in informatica
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
Which are the different editions of informatica powercenter that are available?
Did u used latest transformations of 8.6.0? for what?
How to create or import flat file definition in to the warehouse designer?
Scheduling properties,whats the default (sequential)
What is workflow monitor?
What is informatica?
what is the Default Source Option For Update Strategy Transformation?
