After dragging the ports of 3 sources
sqlserver,oracle,informix to single source qualiofier can
we map these ports directly to target and how?
- 2 Answers
- 6624 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / rao
How can you join 3 heterogeneous sources to a single source
qualifier?.
For this you need to use 2 joiner transformations and the
resulted cloumns can be connected to the target.
| Is This Answer Correct ? | 11 Yes | 0 No |
Answer / veeru
No,
By joining the three sources, we can load in to the target
| Is This Answer Correct ? | 0 Yes | 5 No |
When we are using Dynamic Cache,which options we will select in session level?
There are 4 flat files with number of records as indicated below. Which files should be picked first for joining using joiners so as to get best performance. File A - 1000 records File B - 100 records File c - 10000 records File D - 10 records Please explain. Thanks and Regards,
my source has 2 columns. 1st column data: ABC ABC ABC XYZ and 2nd column data: 1 2 3 4. And my target should be ABC 1 2 3, XYZ 4
What are the types of schemas we have in data warehouse and what are the difference between them?
How can we handle two sessions in informatica?
Explian the Process of deployment groups in informatica
Whats there in global repository
What is a design?
permutations of mapplet
What is the difference between sequential batch and concurrent batch and which is recommended and why?
How to eliminate duplicates in FF and oracle both
How many types of sessions are there in informatica.please explain them?
Teradata 
