What are the basic needs to join two sources in a source
qualifier?
- 3 Answers
- 6653 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / sameer
1) Both sources should be from same Database.
2) They should have a common field which can be used for a
join.
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / krishna
1. two sources must be from same datbase.
2.there should be primary-foreign key relationship between
them.
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / ravi
1) both tables should have PK-FK relationship
2) both should have matching datatypes.
| Is This Answer Correct ? | 4 Yes | 2 No |
What are your source in project and how you import in informatica? How can i explain abt this?
1 Answers Accenture, Unisoft Infotech,
can you avoid static cache in the lookup transformation? I mean can you
Make a note of the quantity vaults made in informatica?
When the informatica server marks that a batch is failed?
How can you differentiate between powercenter and power map?
If one flat file contains n number of records., we have to load the records in target from 51 to 100.. how to use expressions in Informatica..?
How might you approve all mappings in the archive all the while?
what is flat file override?
write a query to follwoing table amount year quarter 254556 2003 first 546332 2003 second 129034 2003 third 490223 2003 fourth 165768 2004 first 265443 2004 second 510412 2004 third 435690 2004 fourth i want the output year q1_amount q2_amount q3_amount q4_amount 2003 254556 546332 129034 490223 2004 165768 265443 510412 435690
What are the issues u have faced in ur project? Guys pls answer to dis question.Due to this question I have failed in 3 interviews.
what is sql override?what is the use of it?
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
Teradata 
