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
- 13344 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / mike
src-->source qual--->exp--->router--->target
based on the conditions we can use other trn's
correct me if i was wrong
| Is This Answer Correct ? | 7 Yes | 11 No |
Post New Answer View All Answers
Sequence generator, when you move from develoment to production how will you reset
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 xml source qualifier transformation in informatica?
what is mean by complex business rule ?
what is $$$$?
How to use procedural logic inside infromatica?
What is a sequence generator transformation?
What is incremental aggregation?
What are the popular informatica products?
How do you take back up of repository?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
Differentiate between sessions and batches?
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.
How to join three sources using joiner? Explain though mapping flow.
Can informatica load heterogeneous targets from heterogeneous sources?
