Interested to Buy Any Domain ? << Click Here >> for more details...
How can we join the tables if they don't have primary and
foreign key relationship and no matching port?
- 7 Answers
- 15621 Views
- I also Faced
- E-Mail Answers
Answer Posted / kishore
Very Simple guys....
Do a Override in SQ:
Select * from Tab1, Tab2
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
What is informatica metadata and where is it stored?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
How to join three sources using joiner? Explain though mapping flow.
What are the conditions needed to improve the performance of informatica aggregator transformation?
What do you mean by enterprise data warehousing?
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
Define Pmrep command?
Explain the use of aggregator cache file?
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
In informatica workflow manager, how many repositories can be created?
What are the different options available for update strategy?
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
Describe data concatenation?
