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
- 13030 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
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
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
difference between repository database and repository service?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
How many number of sessions can one group in batches?
Briefly describe lookup transformation?
How to create or import flat file definition in to the warehouse designer?
Mention few power centre client applications with their basic purpose?
What is dimensional table?
What is informatica? Why do we need it?
What is an aggregator transformation?
What is the benefit of session partitioning?
What are session parameters ? How do you set them?
Explain lookup transformation is active in informatica
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
