Interested to Buy Any Domain ? << Click Here >> for more details...
How to Join Tables my Source is having 15 table target is
one?
- 4 Answers
- 8079 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / balu024
if you have same meta data in all 15 tables, then you can join
those tables by using union transformation
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
Informatica Checkpoints
Explain informatica architecture - version 8 / 9
What is exclusive and normal mode for repository services?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
How can you generate reports 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
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
What is rank transform?
What is an active transformation?
What are session parameters ? How do you set them?
What is a transaction control transformation?
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
To import the flat file definition into the designer where should the flat file be placed?
