Interested to Buy Any Domain ? << Click Here >> for more details...
i have a source table
ID NAME SAL
101 A 1000
102 B 2000
103 C 1500
target load should be
ID NAME SAL
101 A 1000
101 B 2000
101 C 1500
102 A 1000
102 B 2000
102 C 1500
103 A 1000
103 B 2000
103 C 1500
- 3 Answers
- 6279 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / sudheer113
SELECT F1.COL1,F2.COL2,F2.COL3 FROM A F1,A F2 ORDER BY 1,2
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
is it possible to index the data in cache of lkp transformation ?
Under what conditions selecting sorted input in aggregator will still not boost session performance?
What is the function of union transformation?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
What is an expression transformation in informatica?
Why sorter is an active transformation?
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.
What is union transformation in informatica?
Is stop and abort are same in informatica?
Can you generate sequence numbers without using the sequence generator transformation?
Explain dynamic target flat file name generation in informatica
Performance tuning in UNIX for informatica mappings?
What is substr in informatica?
what is the complex transformation you used in informatica
What is the advantage of informatica?
