HOW TO JOIN THE 2 FLAT FILES WITHOUT USING JOINER AND
LOOKUP?
Answers were Sorted based on User's Feedback
Answer / jz
If Two Flat files having same coll then go for Union t/r to
join.
Is This Answer Correct ? | 27 Yes | 10 No |
Answer / amedela chandra sekhar
If two flat files are having same structure then we can join
by using Union transformation.
Chandu
Is This Answer Correct ? | 16 Yes | 1 No |
Answer / ajay konidena
No we can't join two flat file with out using joiner ,look
up
Is This Answer Correct ? | 9 Yes | 3 No |
Answer / sarthak
With the help of command task...
cd dir_path
cat 1st_filename 2nd_filename >> 3rd_filename
Then,
create 1 flatfile and connect it to target.
In session property,
give the filename: 3rd_filename and its path
Is This Answer Correct ? | 6 Yes | 2 No |
Answer / rahul patil
All the above approaches are not correct because question was to join two flat files... if we use indirect file or unix command or joiner trns, we could only union two files but not join.
If we have file1 --- 100 records and
file2 --- 100 records then through above approaches we would have only 200 records.
But a join without join condition would return cartesian product and in our case count should be 10000.
Rahul Patil
DWHKID
Is This Answer Correct ? | 4 Yes | 2 No |
Answer / tulasi pavani.k
If two flat files are of same structure we can join by
creating one list file and by writing the the names of those
two flat files in one text file.
source file directory:c:/order.txt
source file type:indirect
Is This Answer Correct ? | 4 Yes | 3 No |
Answer / murali udayagiri
Use join UNIX command in pre-session command for joining
both the files and write to a file. Use single SQ trans in
mapping to read that joined flat file data.
Thanks,
Murali Udayagiri
Is This Answer Correct ? | 0 Yes | 2 No |
Answer / avru.bal
we can join the 2 flat files by using filerepsitory..save
both files in one directory gve the path name c:\.txt and
provide default type=oracle then apply,
in session properties provide
source file directory:c:/txt
source file type:indirect
provide target connection..so that we can join the both
files without using joiner n lookup
Is This Answer Correct ? | 2 Yes | 8 No |
Answer / sri
SORRY GUYS,BY MISTAKE I POST THE WRONG ANSWER.MAY BE I THINK
INDIRECT METHOD IS CORRECT ONE TO ACHIEVE THIS.
Is This Answer Correct ? | 6 Yes | 16 No |
Answer / senthil
USE SOURCE QUALIFIER WHILE MAPPING CREATED ...
Is This Answer Correct ? | 1 Yes | 20 No |
Converting Rows to columns I have Relational source like his. JAN FEB MAR APR 100 200 300 400 500 600 700 800 900 100 200 300 I need to convert these rows into columns to the targe. MONTH TOTAL JAN 1500 FEB 900 MAR 1200 APR 1500 Please experts help me
guys which is the best institute in banglore to learn informatica??
What is data merging, data cleansing and sampling?
How can u work with remote database in informatica?did you work directly by using remote connections?
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
How can i catch the Duplicate Rows From SorterTrans in a Seperate Target Table ?
what is constraint based loading
where to store informatica rejected data? How to extract the informatica rejected data?
how can we use sorter transformation in joins?
2,can we insert duplicate data with dynamic look up cache,if yes than why and if no why?
What are active transformations.
Differnce between filter and router?