Interested to Buy Any Domain ? << Click Here >> for more details...
HOW TO JOIN THE 2 FLAT FILES WITHOUT USING JOINER AND
LOOKUP?
- 11 Answers
- 32300 Views
- Cap Gemini, I also Faced
- E-Mail Answers
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 |
How you know when to use a static cache and dynamic cache in lookup transformation?
what is scd?
How can one know that a table has indexes and is partitioned? How data will be pulled from Partitions in Oracle for Informatica?
draw informatica architecture 8.6 ?
What is the grain level in DWH? If i have year to day. what is the grain level of DWH from year to day.
What is a pre-defined event and user-defined event?
Hi All, I have three question. 1) How to remove the header and footer in a flat file in informatica? 2)How to load the first and last record of flat file into the target? 3)I have a Input and Output table. Input Name Salaray Month A 100 Jan A 200 Feb A 300 March B 400 April B 500 May B 600 June Output Name Salaray Month A 100 Jan A 300 Feb A 600 March B 400 April B 900 May B 1500 June How to implement and get the ouput as mentioned above. If Possible kindly provide the SQL query also. Kindly any one help to implement this concept. Thanks, Pradeep
Explain pmcmd command usage in informatica
Mention few power centre client applications with their basic purpose?
What are the issues you have faced in your project? How did you overcome those issues?
If a session fails after loading of 10,000 records in to the target.How can you load the records from 10001?
What is the difference b/w natural key and surrogate key
Teradata 
