how to join two flat files in informatica?
- 3 Answers
- 19420 Views
- Wipro, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
If the structure of the two flat files is same we can use SQ.by using in direct
if there is no common field in the two flat files then
create dummy columns in the exp t/r and then by using the dummy columns u can join them in the joiner t/r by giving the condition dummy = dummy1.
the flow is like this
src1--->SQ----->exp--->
|--->joiner---->target
src2--->SQ----->exp--->
| Is This Answer Correct ? | 10 Yes | 0 No |
Hi Rajesh
could you plz tell me the steps to join from joiner tr.
Regards
Mehul Thakur
| Is This Answer Correct ? | 0 Yes | 1 No |
What do you understand by term role-playing dimension?
1.what is SDLC of a project,explain in detail? 2.what are dimensions,facts?what is confirmed dimensions? 3.what is the need of OLTP? when we have datawarehousing?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
How might you approve all mappings in the archive all the while?
i having source, router transformation, two targets in my mapping... i given two conditions in router 1)sal >500 2)sal < 5000 --------------- my source is havig two sal records (1)1000 (2)2000 then which target will load first? will both targets are get load or single target only get load...... why?
What is a connected transformation?
What is workflow manager?
how to find the 5th highest salary form each department using 1.SQL Query 2. Informatica power center designer?
How can one identify whether mapping is correct or not without connecting session?
What is polling?
What are the scheduling options to run a sesion?
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
Teradata 
